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
Re: More efficient OR
Re: More efficient OR
List pgsql-sql
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