Horton

Re: [HACKERS] A small problem with the new inet and cidr types

Hannu Krosing <hannu@trust.ee>

View thread View on postgr.es
From: Hannu Krosing <hannu@trust.ee>
To: "D'Arcy J.M. Cain" <darcy@druid.net>
Cc: jwieck@debis.com, taral@mail.utexas.edu, tgl@sss.pgh.pa.us, pgsql-hackers@postgreSQL.org
Date: 1998-11-03T13:09:12Z
Lists: pgsql-hackers 
D'Arcy J.M. Cain wrote:
> 
> There may be cases where a function of a null is not null as some people
> have pointed out but so far no one has come up with a practical example.

isnull(field)

is_any_null(field1,field2,field3)

are_all_nulls(field1,field2,field3)

value_or_default(NULL,defaultvalue)

---------
Hannu