Обсуждение: Returning row or rows from function?

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

Returning row or rows from function?

От
"David Durst"
Дата:
I want to create a function that will return
a row or rows of a table is this possible?

If so can someone replay with a complete example?




Re: Returning row or rows from function?

От
Stephan Szabo
Дата:
On Wed, 8 Jan 2003, David Durst wrote:

> I want to create a function that will return
> a row or rows of a table is this possible?

It is in 7.3.

> If so can someone replay with a complete example?

You can find some examples in:
http://techdocs.postgresql.org/guides/SetReturningFunctions




Re: Returning row or rows from function?

От
Tomasz Myrta
Дата:
David Durst wrote:

> I want to create a function that will return
> a row or rows of a table is this possible?
>
> If so can someone replay with a complete example?

I propose you reading a document of Stephan Szabo about functions 
returning sets. You need postgresql 7.3 to do this.
http://techdocs.postgresql.org/guides/SetReturningFunctions

Tomasz Myrta