SetOf Functions - Mailing list pgsql-hackers

From Joshua D. Drake
Subject SetOf Functions
Date
Msg-id 43060D6E.8020801@commandprompt.com
Whole thread Raw
Responses Re: SetOf Functions  (Josh Berkus <josh@agliodbs.com>)
Re: SetOf Functions  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Hello,

O.k. I know I can do:

CREATE FUNCTION foo() RETURNS SET OF text AS ' ' language SQL;

Does anyone else think it would be nice to be able to do:

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

?

We could even extend it farther:

CREATE FUNCTION foo() RETURNS SET OF text AS first_name, int4 AS id etc....

Sincerely,

Joshua D. Drake


-- 
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Why is lock not released?
Next
From: Josh Berkus
Date:
Subject: Re: SetOf Functions