Re: CURSORs and selects with parameters

On Tue, Feb 15, 2005 at 02:32:56PM -0500, Dan Sugalski wrote:
>
> I've got some code that uses PQexecParams and does the equivalent of:
>
>    DECLARE a_cursor CURSOR FOR SELECT foo, bar FROM baz WHERE field = $1
>    FETCH NEXT a_cursor
>
> but when I get to the FETCH I'm getting back the error:
>
>    ERROR:  no value found for parameter 1

What version of PostgreSQL are you using?  I think this is fixed
in 8.0.

http://archives.postgresql.org/pgsql-general/2005-01/msg00812.php

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