Search Postgresql Archives

returning a cursor from a function?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux