Обсуждение: PL/pgSQL nested functions
Are there any plans to allow PL/pgSQL functions to be nested like Oracle allows with PL/SQL procedures?
If not, what are the best ways to convert PL/SQL nested procedures to PL/pgSQL?
On 10/06/2010 21:23, Jim.Gray@Bull.com wrote: > > Are there any plans to allow PL/pgSQL functions to be nested like Oracle > allows with PL/SQL procedures? I don't know the answer to your question, but I'm curious - why would you want to nest functions? Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
>...why would you want to nest functions?
I am not nesting the functions myself,
but I am trying to convert existing PL/SQL code to PL/pgSQL.
From what I have seen, the nesting of functions is to modularize the code
and share global variables within the same procedure.
| "Raymond O'Donnell" <rod@iol.ie> 06/10/2010 01:33 PM
|
|
On 10/06/2010 21:23, Jim.Gray@Bull.com wrote:
>
> Are there any plans to allow PL/pgSQL functions to be nested like Oracle
> allows with PL/SQL procedures?
I don't know the answer to your question, but I'm curious - why would
you want to nest functions?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie
On Thu, Jun 10, 2010 at 2:23 PM, <Jim.Gray@bull.com> wrote: > > Are there any plans to allow PL/pgSQL functions to be nested like Oracle > allows with PL/SQL procedures? > > If not, what are the best ways to convert PL/SQL nested procedures to > PL/pgSQL? Well you can call one function from another, so I'd do that.
> Are there any plans to allow PL/pgSQL functions to be nested like Oracle > allows with PL/SQL procedures? > > If not, what are the best ways to convert PL/SQL nested procedures to > PL/pgSQL? > > PostgreSQL plus advanced server (which is a proprietary derivative of postgres) has oracle compatibility features. I'm not specifically aware that it supports nested procedures, but it may well. -- Regards, Peter Geoghegan