Column names in rowsets returned from function

From: Krzysztof Barlik <kbarlik(at)wp(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: Column names in rowsets returned from function
Date: 2009-09-26 16:32:55
Message-ID: 200909261832.55653.kbarlik@wp.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a question - is it possible to rename
columns in rowset returned from plpgsql function
delared as 'returns table(...)' ?

It seems it's not possible, even using
'as "column_name"' in internal query and
column names are always the same as in
'table(...)' definition.

If not, could it be possible in the future ?

Thanks,
Krzysztof

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-09-26 16:44:40 Re: Solaris Postgres
Previous Message Zdenek Kotala 2009-09-26 14:29:11 Re: Solaris Postgres