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/