Обсуждение: returning a cursor from a function?
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@
On Tue, Jan 31, 2006 at 10:37:47PM -0800, Matthew Hixson wrote: > I have a create function statement that works with Oracle 8i and I'm > trying to create this function in Postgres 8.1.2. See the PL/pgSQL documentation, in particular the section on cursors, which has several examples. You might also be interested in the "Porting from Oracle PL/SQL" section. http://www.postgresql.org/docs/8.1/interactive/plpgsql.html http://www.postgresql.org/docs/8.1/interactive/plpgsql-cursors.html http://www.postgresql.org/docs/8.1/interactive/plpgsql-porting.html -- Michael Fuhr
Thanks, Michael. Don't know how I missed those. -M@ On Jan 31, 2006, at 10:55 PM, Michael Fuhr wrote: > On Tue, Jan 31, 2006 at 10:37:47PM -0800, Matthew Hixson wrote: >> I have a create function statement that works with Oracle 8i and I'm >> trying to create this function in Postgres 8.1.2. > > See the PL/pgSQL documentation, in particular the section on cursors, > which has several examples. You might also be interested in the > "Porting from Oracle PL/SQL" section. > > http://www.postgresql.org/docs/8.1/interactive/plpgsql.html > http://www.postgresql.org/docs/8.1/interactive/plpgsql-cursors.html > http://www.postgresql.org/docs/8.1/interactive/plpgsql-porting.html > > -- > Michael Fuhr >