Re: subtratcing dates

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: subtratcing dates
Дата
в 13:21:55
Msg-id
21666.989251229@sss.pgh.pa.us
Ответ на
Re: subtratcing dates (Fran Fabrizio)
Список
Дерево обсуждения
Re: subtratcing dates Fran Fabrizio <ffabrizio@exchange.webmd.net>
Re: subtratcing dates Tom Lane <tgl@sss.pgh.pa.us>
Fran Fabrizio  writes:
> At first, I accidentally tried to do reltime(limit*60) where limit was
> accidentally an interval instead of an integer, and my database crashed
> and exited horribly.

Yeah?  Did you have any nulls in the limit column?
	select reltime(null::interval);
bombs in 7.0 (but is fine in 7.1).  interval_reltime is far from the
only function that's not NULL-proof in pre-7.1 releases :-(

			regards, tom lane
В списке pgsql-general по дате отправления
От: Bruce Momjian
Дата:
От: Lieven Van Acker
Дата:
FAQ