Re: [GENERAL] PIPELINED Functions

2007-11-09 Thread Raymond O'Donnell
On 09/11/2007 15:32, Cesar Alvarez wrote: the Pipelined is the statement so the functions knows he is returning rows. Yes, you can write functions returning rows in pl/pgsql - see the docs, specifically the RETURN NEXT statement. Then the syntax is: select * from my_function(); - the functi

Re: [GENERAL] PIPELINED Functions

2007-11-09 Thread Cesar Alvarez
Reg Me Please wrote: Il Friday 09 November 2007 16:06:34 Cesar Alvarez ha scritto: Hello every one, im working in a proyect that uses Oracle 10g, and nice concept i learn is the PIPELINED functions and Functions that return a Table, is there something alike in Postgres? You do have fun

Re: [GENERAL] PIPELINED Functions

2007-11-09 Thread Reg Me Please
Il Friday 09 November 2007 16:06:34 Cesar Alvarez ha scritto: > Hello every one, > im working in a proyect that uses Oracle 10g, and nice concept i learn > is the PIPELINED functions and Functions that return a Table, > is there something alike in Postgres? You do have functions returning set of r

[GENERAL] PIPELINED Functions

2007-11-09 Thread Cesar Alvarez
Hello every one, im working in a proyect that uses Oracle 10g, and nice concept i learn is the PIPELINED functions and Functions that return a Table, is there something alike in Postgres? begin:vcard fn:Cesar Alvarez n:;Cesar Alvarez title:Web Development Asesor and Software Enginner version: