prepared statements

From: Vad N <vadimid(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: prepared statements
Date: 2011-12-07 23:04:07
Message-ID: CAPuKw9Rp=z=o1GO8fdBJbedjHOc8p-CTYeuV8O9Fz+yWVWNUjQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi.

How can i pass a set of values to prepared statement?

example
I have a prepared query:
select * from users in ( $1 )

i would like to pass: 1,2,3,4 and get:

select * from users in ( 1,2,3,4 )

Any ideas?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message feng.zhou 2011-12-08 01:38:16 Re: Re: [SQL] No response from the backend
Previous Message Scott Marlowe 2011-12-07 20:15:54 Re: Correlating Asterisk CDRs