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 ?
pgsql-novice by date
|Next:||From: Rasmus Mohr||Date: 2002-04-12 10:48:14|
|Subject: Re: Matching a large number of user chosen|
|Previous:||From: thiemo||Date: 2002-04-12 05:38:55|
|Subject: Re: Failing tcp/ip connection|