Re: PQexecParams question

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>, "Postgres General List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PQexecParams question
Date: 2008-10-13 10:30:03
Message-ID: 871vykss7o.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


"Grzegorz Jaśkiewicz" <gryzman(at)gmail(dot)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!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2008-10-13 10:33:50 Re: Chart of Accounts
Previous Message Vladimir Dzhuvinov 2008-10-13 10:24:08 Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?