Re: PREPARE in ECPG

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: BTS <bts_postgresql(at)hotmail(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: PREPARE in ECPG
Date: 2003-06-15 10:58:33
Message-ID: 20030615105833.GE8944@feivel.fam-meskes.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)Fam-Meskes(dot)De
ICQ: 179140304, AIM: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Michael Meskes 2003-06-15 11:00:03 Re: [Fwd: PREPARE in ECPG]
Previous Message Michael Meskes 2003-06-15 10:55:17 Re: PREPARE in ECPG