Re: NULL safe equality operator - Mailing list pgsql-hackers

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