Re: [SQL] Creating nested functions with plpgsql

2006-05-07 Thread Jorge Godoy
Em Domingo 07 Maio 2006 20:33, Alvaro Herrera escreveu: > > We don't support nested functions at present, but you can create a > separate function and invoke it as you would call any external function. Yeah, I know it and that's how I use some things today, but even so, having nested functions he

Re: [SQL] Creating nested functions with plpgsql

2006-05-07 Thread Alvaro Herrera
Jorge Godoy wrote: > I have some real case examples where this could be useful, if it is needed. > I haven't pasted them here because the smallest one has 176 LOC, after > refactoring with nested functions. > > If it is not possible, are there any plans to allow this kind of thing? > (Even with

[SQL] Creating nested functions with plpgsql

2006-05-02 Thread Jorge Godoy
Hi! Is it possible to create nested functions using plpgsql as the language? I'd like to avoid other dependencies if I can, besides using already written SQL code... There are lots of repetitive tasks that "subfunctions" would solve in a very elegant way, keeping code more readable and conc