date - null casted to integer?

Поиск
Список
Период
Сортировка
От Роман Маширов
Тема date - null casted to integer?
Дата
Msg-id 49AD475B.305@nandu.ru
обсуждение исходный текст
Список pgsql-general
Hi!

Excuse me, if this been discussed before, but following thing seems to
me a little bit strange:

select '2009-01-12'::date - null::date < '1 day'::interval;
ERROR:  operator does not exist: integer < interval
LINE 1: select '2009-11-12'::date - null::date < '1 day'::interval;
                                               ^
HINT:  No operator matches the given name and argument type(s). You
might need to add explicit type casts.

select ('2009-11-12'::date - null::date)::interval < '1 day'::interval;
ERROR:  cannot cast type integer to interval
LINE 1: select ('2009-11-12'::date - null::date)::interval < '1 day'...

server 8.3.5 It's really not a problem in queries, but could became a
real pain with plpgsql. I'm not sure, but it seems to me that any
operation with null should product null from the standart's point of view?

Thank you beforehand
--
MRJ



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

Предыдущее
От: Phoenix Kiula
Дата:
Сообщение: Strange behavior: row won't delete
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Strange behavior: row won't delete