Skip site navigation (1) Skip section navigation (2)

Re: select as

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: select as
Date: 2004-12-23 22:22:24
Message-ID: 87wtv8d59b.fsf@stark.xeocode.com (view raw or flat)
Thread:
Lists: pgsql-general
Bambero <bambero(at)tlen(dot)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


In response to

  • select as at 2004-12-23 18:37:14 from Bambero

pgsql-general by date

Next:From: Együd Csaba (Freemail)Date: 2004-12-23 22:23:30
Subject: Re: Very slow stored proc
Previous:From: Derik BarclayDate: 2004-12-23 22:13:42
Subject: Making a varchar bigger

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group