SetOf Functions

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: SetOf Functions
Date: 2005-08-19 16:48:46
Message-ID: 43060D6E.8020801@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-08-19 17:04:30 Re: SetOf Functions
Previous Message Alvaro Herrera 2005-08-19 16:14:33 Why is lock not released?