[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