Re: reltime with NULL fields crashes backend

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: reltime with NULL fields crashes backend
Дата
Msg-id 3AD45FC2.11F937BC@alumni.caltech.edu
обсуждение исходный текст
Ответ на reltime with NULL fields crashes backend  (pgsql-bugs@postgresql.org)
Список pgsql-bugs
> Long Description
> I use expression like int4(reltime(<interval-field>)) to get interval length in seconds. When <interval-field> is
NULLbackend crashes (psql session): 

This is likely fixed in the upcoming 7.1, since NULL handling has been
greatly improved for "by value" types like reltime. However, you *could*
be doing this as

  select date_part('epoch', <interval-field>) ...

hth

                           - Thomas

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