Postgres Pro
Downloads
Home   >   mailing lists

Re: WHERE IN (subselect) versus WHERE IN (1,2,3,) - Mailing list pgsql-general

From Tom Lane
Subject Re: WHERE IN (subselect) versus WHERE IN (1,2,3,)
Date
Msg-id 24314.1332251918@sss.pgh.pa.us
Whole thread Raw
In response to Re: WHERE IN (subselect) versus WHERE IN (1,2,3,)  (Kevin Goess <kgoess@bepress.com>)
List pgsql-general
Tree view 
Kevin Goess <kgoess@bepress.com> writes:
> Thanks for looking into it, Tom.  We're using 9.0.4, so that might indeed
> be the problem. What additional data (if any) would you like to see?

Well, the first thing to do is update to 9.0.latest and see if the plan
changes.  There are plenty of good reasons to do that besides this
issue; see the release notes.

            regards, tom lane

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Conditionnal validation for transaction
Next
From: Alexander Reichstadt
Date:
Subject: PASSWORD vs. md5('somepass')