From: Pavel PaJaSoft Janousek <janousek@fonet.cz>
To: PgSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Selecting more columns in ECPG in one select - error?
Date: Fri, 16 Apr 1999 12:03:09 +0200
Message-ID: <000301be87f0$55753cc0$0200a8c0@server.fonet2.cz> (raw)
Hi all,
I have one trouble.. I have this stable:
create table t (col1 varchar (10), col2 varchar (10), col3 int);
and now, I would like this:
exec sql select col1 into :str1, col2 into :str2 from t where col3 = :cislo;
ECPG distributed with PostgreSQL 6.4.2 say: parse error.
In the older version ECPG, distributed in winter 1997 (I think PGSQL
6.0..?) I use this syntax without errors.
In PSQL I can do also this: select col1, col2 from t where col3 = <number>;
Is this error in yacc definition and will be fixed in version 6.5, or
nobody know this error?
Pavel PaJaSoft Janousek (mailto:janousek@fonet.cz)
FoNet, spol. s r.o. (http://www.fonet.cz/)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: janousek@fonet.cz
Subject: Re: Selecting more columns in ECPG in one select - error?
In-Reply-To: <000301be87f0$55753cc0$0200a8c0@server.fonet2.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox