plpgsql error message

Started by Peter Eisentrautover 16 years ago2 messages
#1Peter Eisentraut
peter_e@gmx.net

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?

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Peter Eisentraut (#1)
Re: plpgsql error message

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