Обсуждение: (No) Autocast in 8.4 with operators "=" and "LIKE"

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.
LINE 1: SELECT 1 LIKE '1';
                 ^
template1=# SELECT version();
                           version
-------------------------------------------------------------
 PostgreSQL 8.4.0, compiled by Visual C++ build 1400, 32-bit
(1 row)


thanks a lot.

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 operator matches the given name and argument type(s). You might need to add explicit type casts.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support