Postgres Pro
Downloads
Home   >   mailing lists

Re: returning a cursor from a function? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: returning a cursor from a function?
Date
Msg-id 20060201065542.GA7477@winnie.fuhr.org
Whole thread Raw
In response to returning a cursor from a function?  (Matthew Hixson <hixson@poindextrose.org>)
Responses Re: returning a cursor from a function?  (Matthew Hixson <hixson@poindextrose.org>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Matthew Hixson
Date:
Subject: returning a cursor from a function?
Next
From: Matthew Hixson
Date:
Subject: Re: returning a cursor from a function?