Re: [GENERAL] Problem with function that returns a cursor

2006-03-03 Thread Michael Fuhr
On Fri, Mar 03, 2006 at 11:06:20AM -0600, Eduardo Muñoz wrote: > I'm new to pgSQL and I'm having some trouble with a > function. I keep getting the following error: > > org.postgresql.util.PSQLException: ERROR: cursor > "" does not exist See my reply to your previous message about this: http://a

[GENERAL] Problem with function that returns a cursor

2006-03-03 Thread Eduardo Muñoz
I'm new to pgSQL and I'm having some trouble with a function. I keep getting the following error: org.postgresql.util.PSQLException: ERROR: cursor "" does not exist This is the function: CREATE OR REPLACE FUNCTION ret_user(pusername "varchar") RETURNS refcursor AS $BODY$ DECLARE ccursor re