pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedSelecting more columns in ECPG in one select - error?
2+ messages / 2 participants
[nested] [flat]
* Selecting more columns in ECPG in one select - error?
@ 1999-04-16 10:03 Pavel PaJaSoft Janousek <janousek@fonet.cz>
1999-04-17 10:32 ` Re: [INTERFACES] Selecting more columns in ECPG in one select - error? Michael Meskes <meskes@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: Pavel PaJaSoft Janousek @ 1999-04-16 10:03 UTC (permalink / raw)
To: pgsql-interfaces
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/)
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] Selecting more columns in ECPG in one select - error?
1999-04-16 10:03 Selecting more columns in ECPG in one select - error? Pavel PaJaSoft Janousek <janousek@fonet.cz>
@ 1999-04-17 10:32 ` Michael Meskes <meskes@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Michael Meskes @ 1999-04-17 10:32 UTC (permalink / raw)
To: Pavel PaJaSoft Janousek <janousek@fonet.cz>; +Cc: pgsql-interfaces
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!
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-04-17 10:32 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-04-16 10:03 Selecting more columns in ECPG in one select - error? Pavel PaJaSoft Janousek <janousek@fonet.cz>
1999-04-17 10:32 ` Michael Meskes <meskes@postgresql.org>
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