Postgres Pro
Downloads
Home   >   mailing lists

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

From Christopher Kings-Lynne
Subject Re: NULL safe equality operator
Date
Msg-id 4386BC12.7050007@familyhealth.com.au
Whole thread Raw
In response to Re: NULL safe equality operator  (Michael Glaesemann <grzm@myrealbox.com>)
Responses Re: NULL safe equality operator  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-hackers
Tree view 
>     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

Chris

pgsql-hackers by date:

Previous
From: Qingqing Zhou
Date:
Subject: Re: gprof SELECT COUNT(*) results
Next
From: Michael Glaesemann
Date:
Subject: Re: NULL safe equality operator