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