(No) Autocast in 8.4 with operators "=" and "LIKE"
От | Daniel Schuchardt |
---|---|
Тема | (No) Autocast in 8.4 with operators "=" and "LIKE" |
Дата | |
Msg-id | h3fi89$ibo$1@news.hub.org обсуждение исходный текст |
Ответы |
Re: (No) Autocast in 8.4 with operators "=" and "LIKE"
|
Список | 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 по дате отправления: