Re: select as - Mailing list pgsql-general

From Greg Stark
Subject Re: select as
Date
Msg-id 87wtv8d59b.fsf@stark.xeocode.com
Whole thread Raw
In response to select as  (Bambero <bambero@tlen.pl>)
List pgsql-general
Bambero <bambero@tlen.pl> writes:

> I don't know what fields are in the table so:
>
> select fieldname as 1, fieldname2 as 2
>
> is useless.

slo=> create table x (foo text,bar text,baz text);
CREATE TABLE
slo=> select * from (select * from x) as x ("1","2","3");
 1 | 2 | 3
---+---+---
(0 rows)

--
greg

pgsql-general by date:

Previous
From: Együd Csaba (Freemail)
Date:
Subject: Re: Very slow stored proc
Next
From: Alvaro Herrera
Date:
Subject: Re: Very slow stored proc