pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feeduser defined function question
3+ messages / 3 participants
[nested] [flat]
* user defined function question
@ 2001-08-15 03:34 Joseph Syjuco <joseph@asti.dost.gov.ph>
2001-08-20 17:51 ` RE: user defined function question Robert J. Sanford, Jr. <rsanford@nolimitsystems.com>
2001-08-20 18:14 ` Re: user defined function question Josh Berkus <josh@agliodbs.com>
0 siblings, 2 replies; 3+ messages in thread
From: Joseph Syjuco @ 2001-08-15 03:34 UTC (permalink / raw)
To: pgsql-sql
how do i return a resultset from a user defined function. pls show a simple
structure
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: user defined function question
2001-08-15 03:34 user defined function question Joseph Syjuco <joseph@asti.dost.gov.ph>
@ 2001-08-20 17:51 ` Robert J. Sanford, Jr. <rsanford@nolimitsystems.com>
1 sibling, 0 replies; 3+ messages in thread
From: Robert J. Sanford, Jr. @ 2001-08-20 17:51 UTC (permalink / raw)
To: Joseph Syjuco <joseph@asti.dost.gov.ph>; pgsql-sql
you can't.
rjsjr
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Joseph Syjuco
> Sent: Tuesday, August 14, 2001 10:34 PM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] user defined function question
>
>
> how do i return a resultset from a user defined function. pls
> show a simple
> structure
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: user defined function question
2001-08-15 03:34 user defined function question Joseph Syjuco <joseph@asti.dost.gov.ph>
@ 2001-08-20 18:14 ` Josh Berkus <josh@agliodbs.com>
1 sibling, 0 replies; 3+ messages in thread
From: Josh Berkus @ 2001-08-20 18:14 UTC (permalink / raw)
To: Joseph Syjuco <joseph@asti.dost.gov.ph>; +Cc: pgsql-sql
Joseph,
> how do i return a resultset from a user defined function. pls show a
> simple
> structure
As of version 7.1.x, you cannot return rowsets from a function. This
feature will be available for future versions.
A number of workarounds have been posted to the list in past months.
Browse through and you should find them.
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-08-20 18:14 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-08-15 03:34 user defined function question Joseph Syjuco <joseph@asti.dost.gov.ph>
2001-08-20 17:51 ` Robert J. Sanford, Jr. <rsanford@nolimitsystems.com>
2001-08-20 18:14 ` Josh Berkus <josh@agliodbs.com>
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