More efficient OR

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: "PostgreSQL SQL" <pgsql-sql(at)postgresql(dot)org>
Subject: More efficient OR
Date: 2005-02-16 16:02:59
Message-ID: 20050216155901.M41773@narrowpathinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Reinoud van Leeuwen 2005-02-16 16:15:08 Re: More efficient OR
Previous Message Eugen Gass 2005-02-16 13:44:30 Trigger