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

[Thomas Hallgren <thhal(at)mailblocks(dot)com>]

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