Achilleus Mantzios wrote: > dynacom=# SELECT '\000\150\145\154\154\157'::text; > text > ------ > > (1 row) > > dynacom=# > > Oops!
text is not bytea. alvherre=# SELECT $$\000\150\145\154\154\157$$::bytea; bytea ----------- \000hello (1 fila) -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match