Re: Multiple IN - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Multiple IN
Date
Msg-id 20011211103057.A29055@wolff.to
Whole thread Raw
In response to Multiple IN  (Leandro Fanzone <leandro@hasar.com>)
List pgsql-novice
On Tue, Dec 11, 2001 at 12:43:08PM -0300,
  Leandro Fanzone <leandro@hasar.com> wrote:
>
> When that list is long, on the one hand I suppose it won't have a good
> performance; on the other, the resultant clause is clumsy and too long.
> Is there any other (more elegant) solution for this? If the field would
> be just one, a simple IN would do better, but as far as I know there is
> no IN for multiple fields.

I am not sure if this is a new feature or just more complete documenation,
but you might want to take a look at this from the 7.2 docs:
http://developer.postgresql.org/docs/postgres/functions-subquery.html

pgsql-novice by date:

Previous
From: Leandro Fanzone
Date:
Subject: Multiple IN
Next
From: "Josh Berkus"
Date:
Subject: Re: Storing number '001' ?