Postgres Pro
Downloads
Home   >   mailing lists

Prepared statement parameters for an 'IN ()' clause - Mailing list pgsql-general

From Jason L. Buberel
Subject Prepared statement parameters for an 'IN ()' clause
Date
Msg-id 47161E1B.9000508@buberel.org
Whole thread Raw
Responses Re: Prepared statement parameters for an 'IN ()' clause  (Sam Mason <sam@samason.me.uk>)
Re: Prepared statement parameters for an 'IN ()' clause  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view
Can someone point me to an example of creating a prepared statement for a query with an 'IN' clause?

The query looks like this:

select value from table where
state = $1 and city = $2 and zip = $3 and
date in ( $4 );

For the prepared statement, I have tried:

prepare st1(text, text, text, text[] );

Then invoked it as:

execute st1('CA', 'SUNNYVALE', '94086', '{2007-10-01,2007-09-25,2007-09-15}' );

But the use of the text array as input parameter does not seem to be correctly used in the 'IN' clause. My query consistently returns no results.

Any quick syntax fix for this?

Thanks
Jason

pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: [HACKERS] CVS and Eclipse
Next
From: Alvaro Herrera
Date:
Subject: Re: What encoding to use for English, French, Spanish