Re: user defined type, plpgsql function and NULL - Mailing list pgsql-sql

From Tom Lane
Subject Re: user defined type, plpgsql function and NULL
Date
Msg-id 19185.1126587535@sss.pgh.pa.us
Whole thread Raw
In response to user defined type, plpgsql function and NULL  ("Bjoern A. Zeeb" <bzeeb-lists@lists.zabbadoz.net>)
List pgsql-sql
"Bjoern A. Zeeb" <bzeeb-lists@lists.zabbadoz.net> writes:
> Is this correct or is it just a "works like that this time but may
> change at any time in the future"?

The meaning of a NULL for a composite value isn't real well-defined
at the moment.  I tend to agree that "fbt IS NULL" should yield true
in your example, but I think there are/were some implementation reasons
why it doesn't.
        regards, tom lane


pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Age in days
Next
From: Michael Fuhr
Date:
Subject: Re: How do I convert an integet to a timestamp?