(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?

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

В списке pgsql-hackers по дате отправления: