Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: >> test=# select null_safe_cmp (NULL,NULL); >> ERROR: could not determine anyarray/anyelement type because input has >> type "unknown" >> Same casting problem due to anyelement, of course.
> Yes - I wonder what the trick to getting around that is? You might be able to hack it by creating a second function defined as null_safe_cmp(unknown,unknown) Pretty grotty of course, and I'm not sure that it comes up in the real world as opposed to test cases. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings