Re: user defined function question - Mailing list pgsql-sql

From Josh Berkus
Subject Re: user defined function question
Date
Msg-id web-105232@davinci.ethosmedia.com
Whole thread Raw
In response to user defined function question  ("Joseph Syjuco" <joseph@asti.dost.gov.ph>)
List 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
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
 


pgsql-sql by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: Sequential select queries...??
Next
From: "Robert J. Sanford, Jr."
Date:
Subject: RE: user defined function question