Postgres Pro
Downloads
Home   >   mailing lists

Re: PQexecParams question - Mailing list pgsql-general

From Gregory Stark
Subject Re: PQexecParams question
Date
Msg-id 871vykss7o.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: PQexecParams question  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
List pgsql-general
Tree view 
"Grzegorz Jaśkiewicz" <gryzman@gmail.com> writes:

> that would be a type mismatch, heh.

prepare "select * from foo where a = any($1::int[])"

then pass "{1,2,3}"

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!

pgsql-general by date:

Previous
From: Vladimir Dzhuvinov
Date:
Subject: Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?
Next
From: Gregory Stark
Date:
Subject: Re: Chart of Accounts