Обсуждение: PIPELINED Functions

Поиск
Список
Период
Сортировка

PIPELINED Functions

От
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?




Вложения

Re: PIPELINED Functions

От
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 rows.

I have no idea about pipelined functions.

--
Reg me Please

Re: PIPELINED Functions

От
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 functions returning set of rows.

I have no idea about pipelined functions.
 
the Pipelined is the statement so the functions knows he is returning rows.
Вложения

Re: PIPELINED Functions

От
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 function takes the place of a table in the SELECT statement.

HTH

Ray.


---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------