From: Michael Meskes <meskes@postgresql.org>
To: Brent Waldrop <waldrop_brent@hotmail.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] esql\c documentation
Date: Mon, 14 Jun 1999 09:16:47 +0200
Message-ID: <19990614091647.A562@gmx.net> (raw)
In-Reply-To: <19990614002236.83551.qmail@hotmail.com>
References: <19990614002236.83551.qmail@hotmail.com>
On Sun, Jun 13, 1999 at 07:24:52PM -0500, Brent Waldrop wrote:
> Does anyone know where this is thorough esql\c documentation. I am trying to
Unfortunately there is no more than the man page and the sgml file
distributed with PostgreSQL. I just didn't find the time to write more.
> compile previous examples i used with informix and they will not work for
> example when i do
> EXEC SQL declare democursor cursor for
> select fname,lname
> into :fname, :lname
> from employee
> where lname < :oneline;
> ---it bombs at the line with "into" in it saying there is a parse error
> and when i do this EXEC SQL fetch democursor;
> --it tells me that there is another parse error on this line
> is there any better documenation for esql/c than whats available in the
> programming manual so that i can figure out what is going on?
To the best of my knowledge this is incorrect syntax. For instance Oracle
says:
The SELECT statement associated with the cursor cannot include an INTO
clause. Rather, the INTO clause and list of output host variables are
part of the FETCH statement.
I cannot find the text in the standard right now, but there also only FETCH
is listed with INTO.
Please correct me if I'm wrong.
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!
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: meskes@postgresql.org, waldrop_brent@hotmail.com
Subject: Re: [INTERFACES] esql\c documentation
In-Reply-To: <19990614091647.A562@gmx.net>
* 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