Re: [HACKERS] (No) Autocast in 8.4 with operators "=" and "LIKE"

2009-07-13 Thread Alvaro Herrera
Daniel Schuchardt wrote: > Is that is the wished behavoir? > > template1=# SELECT 1='1'; > ?column? > -- > t > (1 row) Yes. See also this: alvherre=# select 1 = '1'::text; ERROR: operator does not exist: integer = text LÍNEA 1: select 1 = '1'::text; ^ SUGERENCIA: No o

[HACKERS] (No) Autocast in 8.4 with operators "=" and "LIKE"

2009-07-13 Thread Daniel Schuchardt
Is that is the wished behavoir? template1=# SELECT 1='1'; ?column? -- t (1 row) *template1=# SELECT 1 LIKE '1'; ERROR: operator does not exist: integer ~~ unknown at character 10* HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.