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
/Softwareentwicklung/
www.prodat-sql.de <http://www.prodat-sql.de>