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

From: Daniel Schuchardt <daniel_schuchardt(at)web(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: (No) Autocast in 8.4 with operators "=" and "LIKE"
Date: 2009-07-13 15:02:48
Message-ID: h3fi89$ibo$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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>

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2009-07-13 15:03:34 Re: Index-only-scans, indexam API changes
Previous Message Tom Lane 2009-07-13 14:18:49 Re: Index-only-scans, indexam API changes