On Nov 25, 2005, at 16:24 , Christopher Kings-Lynne wrote:
when ($1 is null and $2 is not null)
or ($1 is not null and $2 is null) then 0
That's the same as:
when $1 is null != $2 is null then 0
Yeah, I saw your commit. Nice shortcut. Also didn't know you could
define operators using SQL functions. Tom's suggestion of NOT (a
DISTINCT FROM b) is really cool. Much cleaner in my opinion. I learn
a lot from these lists :)
Michael Glaesemann
grzm myrealbox com
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq