Re: PQexecParams and CURSOR

On Mon, Jan 17, 2005 at 11:28:57AM +0100, Laurent Marzullo wrote:

> > // res = PQexec( conn , "FETCH 1 FROM MY_CURSOR" );

> The above should work if you uncomment it and comment out or remove
> the other two attempts to execute FETCH.

On my machine (2.6.7-gentoo-r9) and postgreSQL (postmaster --version) :
7.4.6

the command above gave:
FETCH failed: ERROR: no value found for parameter 1

> > /*
> > res = PQexecParams(conn,
> > "FETCH 1 FROM MY_CURSOR",
> > 0,
> > NULL,
> > NULL,
> > NULL,
> > NULL,
> > 0);
> > */

> The above should also work if you uncomment it and comment out or
> remove the other two.

This one alose gave the same result as the preceding one:

FETCH failed: ERROR: no value found for parameter 1

My I install a version greater than 7.4.6 ?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/