Re: User defined data type

Поиск
Список
Период
Сортировка
От Don Y
Тема Re: User defined data type
Дата
Msg-id 44336176.20307@DakotaCom.Net
обсуждение исходный текст
Ответ на Re: User defined data type  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane wrote:
> Martijn van Oosterhout <kleptog@svana.org> writes:
>> On Thu, Mar 30, 2006 at 11:51:41AM -0700, Don Y wrote:
>>> - Can *_in() be ever invoked with a NULL argument?  Or, can I
>>> safely assume that the pointer I am passed is valid?
>
>> You can't get a NULL there. Yes, the pointer is valid cstring.

Yes, STRICT IMMUTABLE, in my case, so not a problem.

> To be sure about that, make sure you mark the function STRICT
> when you define it.  Otherwise you can get burnt by direct user
> invocation
>     select int4in(null::cstring);
> not to mention that we were recently considering letting non-strict
> input functions get invoked on nulls in the normal course of events.

Thanks!
--don

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

Предыдущее
От: Don Y
Дата:
Сообщение: Re: User defined data type
Следующее
От: "hubert depesz lubaczewski"
Дата:
Сообщение: Re: database design questions