Postgres Pro
Downloads
Home   >   mailing lists

Re: exclusive OR possible within a where clause? - Mailing list pgsql-general

From Tom Lane
Subject Re: exclusive OR possible within a where clause?
Date
Msg-id 9898.1318549799@sss.pgh.pa.us
Whole thread Raw
In response to exclusive OR possible within a where clause?  (David Salisbury <salisbury@globe.gov>)
Responses Re: exclusive OR possible within a where clause?  (David Fetter <david@fetter.org>)
List pgsql-general
Tree view 
David Salisbury <salisbury@globe.gov> writes:
> Short version, is there a way to implement an exclusive OR in a where clause?

The boolean <> operator will do the trick.

    (x = y) <> (a = b)

            regards, tom lane

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Error: timestamp with timezone + interval is not immutable while creating index
Next
From: René Fournier
Date:
Subject: Re: PostGIS: Approximating a house number from street address range