Re: SELECT 1st field - Mailing list pgsql-sql

From Tom Lane
Subject Re: SELECT 1st field
Date
Msg-id 21931.1337079664@sss.pgh.pa.us
Whole thread Raw
In response to SELECT 1st field  (Jan Bakuwel <jan.bakuwel@greenpeace.org>)
Responses Re: SELECT 1st field
List pgsql-sql
Jan Bakuwel <jan.bakuwel@greenpeace.org> writes:
> What I need is the ability to name the column in the view, ie.

> create view v as select 1 as "id" from func(5);

I think what you're looking for is the ability to re-alias a column name,
for example
select id from func(5) as foo(id);
        regards, tom lane


pgsql-sql by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: Finding Max Value in a Row
Next
From: Misa Simic
Date:
Subject: Re: SELECT 1st field