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

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