IN () vs. BETWEEN differences

From: Brian Ghidinelli <brian(at)pukkasoft(dot)com>
To: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: IN () vs. BETWEEN differences
Date: 2011-07-21 20:36:34
Message-ID: 4E288DD2.2020001@pukkasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug


I think the answer is no, but this would settle a debate. Assuming the
IN() example contains the complete set of values between 10 and 40, is
there any practical or other differences between:

WHERE integer_field IN (10, 11, 12, 13, 21, 22, 23, 30, 31, 32)

and

WHERE integer_field BETWEEN 10 AND 40

Thanks!

Brian

Responses

Browse sfpug by date

  From Date Subject
Next Message Christophe Pettus 2011-07-21 20:50:33 Re: IN () vs. BETWEEN differences
Previous Message Joshua D. Drake 2011-07-19 23:13:02 CFP for West closes in two weeks