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