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.