Received: from www.flamingo.cz (root@fwd.cz [194.212.23.91])
	by hub.org (8.9.2/8.9.1) with ESMTP id XAA60449
	for <pgsql-interfaces@postgresql.org>;
	Fri, 16 Apr 1999 23:04:12 -0400 (EDT)
	(envelope-from janousek@fonet.cz)
Received: from router.fonet2.cz (ts3-1.bm.cesnet.cz [194.212.133.32])
	by www.flamingo.cz (8.8.8/8.8.8) with ESMTP id FAA01356
	for <pgsql-interfaces@postgresql.org>; Sat, 17 Apr 1999 05:04:09 +0200
Received: from server (server.fonet2.cz [192.168.0.2])
	by router.fonet2.cz (8.9.1/8.9.1) with SMTP id MAA10118
	for <pgsql-interfaces@postgresql.org>; Fri, 16 Apr 1999 12:05:26 GMT
Message-ID: <000301be87f0$55753cc0$0200a8c0@server.fonet2.cz>
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
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-2"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

    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/)