Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: NULL safe equality operator

  • From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
  • To: Michael Glaesemann <grzm(at)myrealbox(dot)com>
  • Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
  • Subject: Re: NULL safe equality operator
  • Date: Fri, 25 Nov 2005 16:06:46 +0800
  • Message-id: <4386C616(dot)6090500(at)familyhealth(dot)com(dot)au>
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?

Chris
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group