[TYPO3] problem with POSTGRE bytea+bigint
Tomas Majer
tomasmajer at gmail.com
Sun Jun 3 13:38:39 CEST 2007
hi
i have problem with typo3 and postgre
i would like to execute query like this:
select * from table1 left join table2 on table2.parent=table1.uid
but problem is when typo3 is creating table2, the field 'parent' is bytea and in table1.uid is bigint
postgre cannot compare this types -> error: operator does not exist: bytea = bigint
then i create my own function and operator
function works, but operator is doing something strange
it looks like this:
CREATE OPERATOR "public".== ( PROCEDURE = "public"."function1",
LEFTARG = bytea, RIGHTARG = bigint,
COMMUTATOR = "public".=, NEGATOR = "public".!,
RESTRICT = "eqsel", JOIN = "eqjoinsel",
HASHES);
when i execute my query now with ... on table2.parent==table1.uid ...
i get result with table1 data and joined table2 data is null
is there anybody who can help me?
thanks
tomaj :-)
More information about the TYPO3-english
mailing list