(No) Autocast in 8.4 with operators "=" and "LIKE" - Mailing list pgsql-hackers

From Daniel Schuchardt
Subject (No) Autocast in 8.4 with operators "=" and "LIKE"
Date
Msg-id h3fi89$ibo$1@news.hub.org
Whole thread Raw
Responses Re: (No) Autocast in 8.4 with operators "=" and "LIKE"  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Is that is the wished behavoir?<br /><br /><font color="#33cc00">template1=# SELECT 1='1';</font><br />  ?column?<br
/>----------<br />  t<br /> (1 row)<br /><br /><font color="#ff0000"><b>template1=# SELECT 1 LIKE '1';<br /> ERROR: 
operatordoes not exist: integer ~~ unknown at character 10</b></font><br /> HINT:  No operator matches the given name
andargument type(s). You might need to add explicit type casts.<br /> LINE 1: SELECT 1 LIKE '1';<br />                 
^<br/> template1=# SELECT version();<br />                            version<br />
-------------------------------------------------------------<br/>  PostgreSQL 8.4.0, compiled by Visual C++ build
1400,32-bit<br /> (1 row)<br /><br /><br /> thanks a lot.<br /><div class="moz-signature">-- <br /><p>Daniel
Schuchardt<br/><i><font size="2">Softwareentwicklung</font></i><p><font size="2"><a
href="http://www.prodat-sql.de">www.prodat-sql.de</a></font></div>

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Index-only-scans, indexam API changes
Next
From: Tom Lane
Date:
Subject: Re: Index-only-scans, indexam API changes