Re: Function that returns a tuple.

Claudio,

> How can I write a function in sql or pl- pgsql that returns a set of
> tuples ?

I've had the same question myself for the past month, which has gone
unanswered (hint, hint, Jeff!). Currently I'm using custom functions to
build views and then referenceing the views:

CREATE FUNCTION fun_generate_statistics (
do a bunch of stuff, ending with:
CREATE VIEW vw_generate_statistics (
bunch of stuff);
);

Then the front-end code references vw_generate_statistics.

Not elegant, but sufficient until I hear from Jeff or Jan Wieck.

-Josh Berkus

--
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 436-9166
for law firms, small businesses fax 436-0137
and non-profit organizations. pager 338-4078
San Francisco