[GENERAL] returning a cursor from a function?

[Matthew Hixson]

I have a create function statement that works with Oracle 8i and I'm  
trying to create this function in Postgres 8.1.2.

CREATE OR REPLACE FUNCTION pr_user( p0 CHAR ) RETURN  
Types.cursor_type IS
rs Types.cursor_type;
BEGIN
OPEN rs FOR
SELECT us.approval_type_code AS us_approval_type_code FROM wbs_users  
us WHERE upper( us.username ) = upper( p0 );
return rs;
END;
Could someone lend me a hand here?
  Thanks in advance,
   -M@

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly