Re: another index question

From: Sean Harding <sharding(at)dogcow(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: another index question
Date: 2001-04-01 21:34:11
Message-ID: 20010401143411.R22353@dogcow.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun Apr 01 at 05:22:34 PM, Tom Lane wrote:

> Since you know the subselect is going to produce exactly one tuple,
> there's no need to use IN.

Thanks Tom. That definitely helps a lot.

sean

--
Sean Harding sharding(at)dogcow(dot)org | "Never before and never since, I promise,
http://www.dogcow.org/sean/ | will the whole world be warm as this."
| -- 10,000 Maniacs

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Denis A. Doroshenko 2001-04-01 22:13:46 Re: Ok, why isn't it using *this* index?
Previous Message Paul Tomblin 2001-04-01 21:32:46 Re: Ok, why isn't it using *this* index?