Re: IN () vs. BETWEEN differences

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


Christophe,

Well played sir, well played.

Brian, riding out my "Friday" today...

On 7/21/2011 1:50 PM, Christophe Pettus wrote:
> postgres=# explain analyze select i from x where i in (10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40);

In response to

Browse sfpug by date

  From Date Subject
Next Message Josh Berkus 2011-07-23 00:31:06 [commercial] Survey on PostgreSQL training in San Francisco
Previous Message Christophe Pettus 2011-07-21 20:50:33 Re: IN () vs. BETWEEN differences