Обсуждение: user defined function question

how do i return a resultset from a user defined function. pls show a simple
structure

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
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 

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)
>