Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] esql\c documentation

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Brent Waldrop <waldrop_brent(at)hotmail(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] esql\c documentation
Date: 1999-06-14 07:16:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
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

   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 Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael(dot)Meskes(at)gmx(dot)net          | Use PostgreSQL!

In response to


pgsql-interfaces by date

Next:From: Peter MountDate: 1999-06-14 07:29:24
Subject: RE: [INTERFACES] JDBC driver. ResultSet.absolute(int row)
Previous:From: Peter HarveyDate: 1999-06-14 06:29:53
Subject: Re: [INTERFACES] hacked unixodbc driver..

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group