Thread: Returning row or rows from function?

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?

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

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