Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: NULLs ;-)
- From: "John D. Burger" <john(at)mitre(dot)org>
- To: pgsql general <pgsql-general(at)postgresql(dot)org>
- Subject: Re: NULLs ;-)
- Date: Tue, 28 Nov 2006 09:42:38 -0500
- Message-id: <BA11E4CF-9E04-4F35-AFA2-81B81AB5D084(at)mitre(dot)org>
Scott Ribe wrote:
where a <> b or (a is null and b is not null) or (a is not null and b is null)
In the absence of IS DISTINCT FROM, I think this has the same semantics: where coalesce(a, b) <> coalesce(b, a) although it's not as concise as one might wish. - John D. Burger MITRE
- Follow-Ups:
- Re: NULLs ;-)
- From: Ragnar
- Re: NULLs ;-)
- References:
- NULLs ;-)
- From: Scott Ribe
- NULLs ;-)
- Prev by Date: Re: IN clause
- Next by Date: Re: How to increace nightly backup speed
- Previous by thread: Re: NULLs ;-)
- Next by thread: Re: NULLs ;-)
- Indexes: