IN should not be that much faster, as the table is scanned for each entry in
the list of id numbers.
--------------------------------------------------------------
Rasmus T. Mohr Direct : +45 36 910 122
Application Developer Mobile : +45 28 731 827
Netpointers Intl. ApS Phone : +45 70 117 117
Vestergade 18 B Fax : +45 70 115 115
1456 Copenhagen K Email : mailto:rmo@netpointers.com
Denmark Website : http://www.netpointers.com
"Remember that there are no bugs, only undocumented features."
--------------------------------------------------------------
-----Oprindelig meddelelse-----
Fra: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]Pa vegne af Rob
Sendt: 12. april 2002 18:11
Til: John Taylor
Cc: pgsql-novice@postgresql.org
Emne: Re: [NOVICE] Matching a large number of user chosen
Hi John,
>
> 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 ?
You could try
AND id in ('123','456','789');
--
Rob
He who dies with the most toys ...
... still dies
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
