Re: NULL safe equality operator

[Michael Glaesemann <grzm(at)myrealbox(dot)com>]

On Nov 25, 2005, at 17:06 , Christopher Kings-Lynne wrote:

> > test=# select null_safe_cmp (NULL,NULL);
> > ERROR:  could not determine anyarray/anyelement type because  
> > input  has type "unknown"
> > test=# select null_safe_cmp (NULL::integer,NULL::integer);
> > null_safe_cmp
> > ---------------
> >              1
> > (1 row)
> > Same casting problem due to anyelement, of course.
>
> Yes - I wonder what the trick to getting around that is?

Don't use NULL.

Michael Glaesemann
grzm myrealbox com