Matching a large number of user chosen - Mailing list pgsql-novice

From John Taylor
Subject Matching a large number of user chosen
Date
Msg-id 02041210484101.01886@splash.hq.jtresponse.co.uk
Whole thread Raw
Responses Re: Matching a large number of user chosen
List pgsql-novice
Hi,

I have an application where a user can choose a large number of distinct products to process.

The SQL that I currently use looks something like this:

select * from products where date='01012000' AND ( id='123' OR id='456' OR id='789' );

There can be maybe hundreds of different unconnected id's chosen.

Is there a more elegant/efficient way to do this than a large number of ORs ?

Thanks
JohnT

pgsql-novice by date:

Previous
From: Rob
Date:
Subject: Update function
Next
From: Rob
Date:
Subject: Re: Matching a large number of user chosen