Postgres Pro
Downloads
Home   >   mailing lists

More efficient OR - Mailing list pgsql-sql

From Keith Worthington
Subject More efficient OR
Date
Msg-id 20050216155901.M41773@narrowpathinc.com
Whole thread Raw
Responses Re: More efficient OR  (Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>)
Re: More efficient OR  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: More efficient OR  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-sql
Tree view 
Hi All,

In several of my SQL statements I have to use a WHERE clause that contains
mutiple ORs.  i.e.

WHERE column1 = 'A' OR     column1 = 'B' OR     column1 = 'C'

Is there a more efficient SQL statement that accomplishes the same limiting
functionality?

Kind Regards,
Keith

pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Making NULL entries appear first when ORDER BY ASC
Next
From: Reinoud van Leeuwen
Date:
Subject: Re: More efficient OR