Re: User defined data type - Mailing list pgsql-general

From Tom Lane
Subject Re: User defined data type
Date
Msg-id 22849.1143750060@sss.pgh.pa.us
Whole thread Raw
In response to Re: User defined data type  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: User defined data type  (Don Y <pgsql@DakotaCom.Net>)
List pgsql-general
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.

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.

            regards, tom lane

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: User defined data type
Next
From: "sylsau"
Date:
Subject: Use functions in Pl/Perl language