Postgres Pro
Downloads
Home   >   mailing lists

Where clause efficiency using "IN" - Mailing list pgsql-novice

From Sean Davis
Subject Where clause efficiency using "IN"
Date
Msg-id 20C3B01D-243C-11D9-8BC9-000A95D7BA10@mail.nih.gov
Whole thread Raw
Responses Re: Where clause efficiency using "IN"  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Where clause efficiency using "IN"  (Steven Klassen <sklassen@commandprompt.com>)
Re: Where clause efficiency using "IN"  ("Scott Marlowe" <smarlowe@qwest.net>)
List pgsql-novice
Tree view 
Just a quick general question:  Can someone comment on using where
clauses like:

(sample = 2 OR sample = 3 OR sample = 4)

as compared to

sample in (2,3,4)

in terms of efficiency?

Thanks,
Sean

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: Add ON UPDATE CASCADE to an existing table
Next
From: Tom Lane
Date:
Subject: Re: Where clause efficiency using "IN"