Re: [GENERAL] Returning a RECORD, not SETOF RECORD

Michael Fuhr wrote:

>On Thu, Apr 28, 2005 at 09:47:45PM +0200, Thomas Hallgren wrote:
>
>
>>>What version of PostgreSQL are you using
>>>
>>>
>>The latest and greatest from CVS.
>>
>>
>
>Which branch? HEAD? REL8_0_STABLE?
>
>
Sorry. To me "latest" always defaults to HEAD and by "greatest" I mean
the coming 8.1.

>
>
>>Wouldn't it make sense to be able to define a record in the projection
>>part of a query, similar to what I was attempting with my SELECT? Has
>>this been discussed or is it just considered as not very useful?
>>
>>
>
>Sounds reasonable to me, but if it's currently possible then I
>haven't yet figured out how to do it. I can't remember if it's
>been discussed before or not. If nobody answers here then you
>might try pgsql-hackers.
>
>
>
Ok. Thanks. I'll redirect this to hackers and see if I have any luck
there. My original question was:

I do the following:

CREATE FUNCTION xyz(int, int) RETURNS RECORD AS '...'
CREATE TABLE abc(a int, b int);

Now I want to call my xyz function once for each row in abc and I want
my RECORD to be (x int, y int, z timestamptz). How do I write that
query? I.e. where do specify my RECORD definition? Is it possible at
all? Ideally I'd like to write something like this:

SELECT xyz(a, b) AS (x int, y int, z timestamptz) FROM abc;

but that yields a syntax error.

Regards,
Thomas Hallgren