Re: returning a cursor from a function?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Matthew Hixson <hixson(at)poindextrose(dot)org>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: returning a cursor from a function?
Date: 2006-02-01 06:55:42
Message-ID: 20060201065542.GA7477@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Hixson 2006-02-01 07:08:22 Re: returning a cursor from a function?
Previous Message Matthew Hixson 2006-02-01 06:37:47 returning a cursor from a function?