Re: Problem regarding 'select...as...' - Mailing list pgsql-sql

From Jesus Aneiros
Subject Re: Problem regarding 'select...as...'
Date
Msg-id Pine.LNX.4.10.10006130117100.9993-100000@jagua.cfg.sld.cu
Whole thread Raw
In response to Problem regarding 'select...as...'  (Bernie Huang <bernie.huang@ec.gc.ca>)
List pgsql-sql
I think the correct way is

SELECT equipo_attr[1] AS year, equip_attr[2] AS make 
FROM vehicle_tb;

On Mon, 12 Jun 2000, Bernie Huang wrote:

> Hi, I have a following query:
> 
> "select equip_attr[1], equip_attr[2]
> as year, make
> from vehicle_tb;"
> 
> which gives me the following error:
> 
> "ERROR:  Attribute 'make' not found"
> 
> Is there something wrong with my "as" usage?  Thanks
> 
> 
> - Bernie
> 



pgsql-sql by date:

Previous
From: GANESH KUMAR
Date:
Subject: sql foregein key
Next
From: Herbert Rabago Ambos
Date:
Subject: Re: sql foregein key