On 4/13/07, Steve P Shiflett <[EMAIL PROTECTED]> wrote:
I wish to display the output of a cursor but haven't discovered the trick.
Here's what I'm doing:
According to the documentation, you can fetch from a returned
refcursor like this:
FETCH ALL IN "<unnamed cursor 1>";
You can name the refcusor inside your function like this:
my_cursor refcursor default 'something';
which makes it easier to get from sql script from a known name.
merlin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
