Re: PL/pgSQL question - Mailing list pgsql-sql

From Josh Berkus
Subject Re: PL/pgSQL question
Date
Msg-id 200302021359.53890.josh@agliodbs.com
Whole thread Raw
In response to  ("mail.luckydigital.com" <jim@luckydigital.com>)
List pgsql-sql
Jim,

> Yes i'm aware this it is possible in 7.3 - can someone please confirm its
> not possible in 7.2 or provide me with an example of how to go about it.

It is sort of possible in 7.2, as a function can return a cursor to an
interface language capable of handling cursors.   However, implementation is
quite cumbersome, and I won't try to detail it here, particularly since that
language and method have been obsolesced and would force you to re-write your
code when you do upgrade.

If this feature is important to you, I strongly recommend that you upgrade to
7.3.1 now.

--
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-sql by date:

Previous
From: "mail.luckydigital.com"
Date:
Subject:
Next
From: Oliver Elphick
Date:
Subject: Re: