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