Postgres Pro
Downloads
Home   >   mailing lists

Re: SetOf Functions - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: SetOf Functions
Date
Msg-id 200508191008.49475.josh@agliodbs.com
Whole thread Raw
In response to SetOf Functions  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: SetOf Functions  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
Tree view 
Josh,

> CREATE FUNCTION foo() RETURNS SET OF text,int4,float,timestamp AS ' '
> language SQL;

You can effectively do this with the new INOUT syntax.  Check it out in the 
8.1devel docs.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: SetOf Functions
Next
From: Tom Lane
Date:
Subject: Re: Why is lock not released?