Re: plpgsql error message - Mailing list pgsql-hackers

From Tom Lane
Subject Re: plpgsql error message
Date
Msg-id 27153.1245252312@sss.pgh.pa.us
Whole thread Raw
In response to plpgsql error message  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> In plpgsql, if you write
> OPEN var BLAH

> you can an error message like this:

> ERROR:  syntax error ...
> DETAIL:  Expected "FOR", to open a reference cursor.

> But what is a "reference cursor"?  Isn't this rather saying "... to open a 
> cursor, a reference to which will be stored in your variable"?  Anyone got a 
> better idea for a wording?

The documentation uses the phrase "unbound cursor".  +1 for changing it
--- I don't see any other uses of "reference cursor", except in
pg_type.h where type "refcursor" is commented that way.  And that should
probably read "reference to cursor".
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Determining client_encoding from client locale
Next
From: Alvaro Herrera
Date:
Subject: Re: Determining client_encoding from client locale