pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedReturning row or rows from function?
3+ messages / 3 participants
[nested] [flat]
* Returning row or rows from function?
@ 2003-01-09 06:21 David Durst <ddurst@larubber.com>
0 siblings, 2 replies; 3+ messages in thread
From: David Durst @ 2003-01-09 06:21 UTC (permalink / raw)
To: pgsql-sql
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Returning row or rows from function?
@ 2003-01-13 18:43 Stephan Szabo <sszabo@megazone23.bigpanda.com>
parent: David Durst <ddurst@larubber.com>
1 sibling, 0 replies; 3+ messages in thread
From: Stephan Szabo @ 2003-01-13 18:43 UTC (permalink / raw)
To: David Durst <ddurst@larubber.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Returning row or rows from function?
@ 2003-01-13 18:48 Tomasz Myrta <jasiek@klaster.net>
parent: David Durst <ddurst@larubber.com>
1 sibling, 0 replies; 3+ messages in thread
From: Tomasz Myrta @ 2003-01-13 18:48 UTC (permalink / raw)
To: ddurst@larubber.com; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-01-13 18:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-09 06:21 Returning row or rows from function? David Durst <ddurst@larubber.com>
2003-01-13 18:43 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2003-01-13 18:48 ` Tomasz Myrta <jasiek@klaster.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox