Received: from clubserv.rp-online.de (clubserv.rp-online.de [149.221.232.11]) by hub.org (8.9.2/8.9.1) with ESMTP id PAA60564 for ; Sat, 17 Apr 1999 15:40:53 -0400 (EDT) (envelope-from Michael.Meskes@gmx.net) Received: from pc63.rp-plus.de (as11-asy83.rp-plus.de [149.221.93.211]) by clubserv.rp-online.de (8.9.1a/8.9.1) with ESMTP id VAA01627; Sat, 17 Apr 1999 21:40:22 +0200 (METDST) Received: (from meskes@localhost) by pc63.rp-plus.de (8.9.3/8.9.3/Debian/GNU) id MAA07693; Sat, 17 Apr 1999 12:32:09 +0200 Date: Sat, 17 Apr 1999 12:32:08 +0200 From: Michael Meskes To: Pavel PaJaSoft Janousek Cc: PgSQL Interfaces Subject: Re: [INTERFACES] Selecting more columns in ECPG in one select - error? Message-ID: <19990417123208.A6263@gmx.net> Mail-Followup-To: Pavel PaJaSoft Janousek , PgSQL Interfaces References: <000301be87f0$55753cc0$0200a8c0@server.fonet2.cz> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.4i In-Reply-To: <000301be87f0$55753cc0$0200a8c0@server.fonet2.cz>; from Pavel PaJaSoft Janousek on Fri, Apr 16, 1999 at 12:03:09PM +0200 On Fri, Apr 16, 1999 at 12:03:09PM +0200, Pavel PaJaSoft Janousek wrote: > and now, I would like this: > exec sql select col1 into :str1, col2 into :str2 from t where col3 = :cislo; Please correct me if I'm wrong but IMO the correct syntax is: exec sql select col1, col2 into :str1, :str2 from t where col3 = :cislo; > In the older version ECPG, distributed in winter 1997 (I think PGSQL > 6.0..?) I use this syntax without errors. Yes, that old version did not really check the syntax. > Is this error in yacc definition and will be fixed in version 6.5, or > nobody know this error? I think the 1997 version is the buggy one. Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael.Meskes@gmx.net | Use PostgreSQL!