Re: PREPARE in ECPG - Mailing list pgsql-interfaces

From Michael Meskes
Subject Re: PREPARE in ECPG
Date
Msg-id 20030615105833.GE8944@feivel.fam-meskes.de
Whole thread Raw
In response to Re: PREPARE in ECPG  ("BTS" <bts_postgresql@hotmail.com>)
List pgsql-interfaces
On Wed, May 28, 2003 at 08:58:56AM +0200, BTS wrote:
> We hope to be able to write statements like:
>   EXEC SQL
>     PREPARE stm (char(5), int) as SELECT a,b,c INTO :host_a, :host_b,
> :host_c
>                                   FROM mytable WHERE d=$1 AND e=$2;

Are you able to do this via psql? I.e. can you specify a placeholder
like $1 in psql?

Michael
-- 
Michael Meskes
Email: Michael@Fam-Meskes.De
ICQ: 179140304, AIM: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!


pgsql-interfaces by date:

Previous
From: Michael Meskes
Date:
Subject: Re: PREPARE in ECPG
Next
From: Michael Meskes
Date:
Subject: Re: [Fwd: PREPARE in ECPG]