interesting difference for queries...

Поиск
Список
Период
Сортировка
От Mario Weilguni
Тема interesting difference for queries...
Дата
Msg-id 4D618F6493CE064A844A5D496733D66703921E@freedom.icomedias.com
обсуждение исходный текст
Ответы Re: interesting difference for queries...
Список pgsql-hackers
I noticed an interesting difference in query behaviour:

cms=# CREATE TABLE foo(bar int);
CREATE
cms=# SELECT * from foo where bar=1.7;bar
-----
(0 rows)

cms=# SELECT * from foo where bar='1.7';
ERROR:  pg_atoi: error in "1.7": can't parse ".7"

Is this the same problem as index usage with/without quotes? However, one
would expect the same output from both queries, either the error message, or
better the 0 rows result.

RegardsMario Weilguni


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