PREPARE query with IN? - Mailing list pgsql-general

From Ivan Voras
Subject PREPARE query with IN?
Date
Msg-id h5d1d0$11l$1@ger.gmane.org
Whole thread Raw
Responses Re: PREPARE query with IN?  (Filip Rembiałkowski <plk.zuber@gmail.com>)
List pgsql-general
Is it possible to prepare a query with the IN clause in a meaningful
way? I could probably do it with a hard-coded number of arguments, like
"SELECT x FROM t WHERE y IN ($1, $2, $3)" but that kind of misses the
point of using IN for my needs.

In any case, it would probably be a good idea to add a sentence about it
on http://www.postgresql.org/docs/8.3/interactive/sql-prepare.html since
I'm probably not the first one to ask about it :)

pgsql-general by date:

Previous
From: Eric Schwarzenbach
Date:
Subject: Re: explicit JOIN faster than implicit?
Next
From: Christine Desmuke
Date:
Subject: Re: Make check fails on 8.3.7