Returning NULL from functions

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Returning NULL from functions
Дата
Msg-id 3BA94E0F.825B718F@fourpalms.org
обсуждение исходный текст
Ответы Re: Returning NULL from functions
Список pgsql-hackers
I am working on date/time stuff, and in the spirit of cleaning up
interesting but marginally useful features I've dropped support for
"invalid" for the timestamp and timestamptz types. 

To help with upgrading, I thought that I'd map it to a NULL value, and
see the following in the regression tests:

-- Obsolete special values
INSERT INTO TIMESTAMP_TBL VALUES ('invalid');
ERROR:  OidFunctionCall3: function 1150 returned NULL

Is this error message a feature of all returns of NULL, particular to
input routines, or can I somehow mark routines as being allowed to
return NULL values?

Comments?
                       - Thomas


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: CVS vs anoncvs (was Re: Case sensitive file names)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: type casting troubles