Re: [GENERAL] PL/pgSQL nested functions

2010-06-11 Thread Peter Geoghegan
> 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 compatibi

Re: [GENERAL] PL/pgSQL nested functions

2010-06-10 Thread Scott Marlowe
On Thu, Jun 10, 2010 at 2:23 PM, 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.

Re: [GENERAL] PL/pgSQL nested functions

2010-06-10 Thread Raymond O'Donnell
On 10/06/2010 21:23, jim.g...@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 ::

[GENERAL] PL/pgSQL nested functions

2010-06-10 Thread Jim . Gray
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?

Re: [GENERAL] PL/pgSQL nested functions

2010-06-10 Thread Jim . Gray
d O'Donnell" 06/10/2010 01:33 PM Please respond to r...@iol.ie To jim.g...@bull.com cc pgsql-general@postgresql.org Subject Re: [GENERAL] PL/pgSQL nested functions On 10/06/2010 21:23, jim.g...@bull.com wrote: > > Are there any plans to allow PL/pgSQL functions to be neste