Unable to convert null timestamp to date. Bug?

Поиск
Список
Период
Сортировка
От Edmar Wiggers
Тема Unable to convert null timestamp to date. Bug?
Дата
Msg-id NEBBIAKDCDHFGJMLHCKIMEPKCBAA.edmar@brasmap.com
обсуждение исходный текст
Ответы Re: Unable to convert null timestamp to date. Bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Strange, this works: select * from users where last_visit > now() + 7;  -- last_visit is nullable, of type timestamp

But this doesn't select * from users where last_visit + 7 > now(); ERROR:  Unable to convert null timestamp to date --
yes,there are users where last_visit IS NULL
 

BTW, this works too: select null+1; -- obviously returns NULL

System is FreeBSD 4.1, PgSQL 7.0.2

Anyone got a clue?

Yours sincerely,

Edmar Wiggers
BRASMAP Information Systems
+55 48 9960 2752


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: trying to pattern match to a value contained in a column
Следующее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: trying to pattern match to a value contained in a column