Postgres Pro
Downloads
Home   >   mailing lists

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

From Bernie Huang
Subject Problem regarding 'select...as...'
Date
Msg-id 394564F8.4B5EE3F7@ec.gc.ca
Whole thread Raw
Responses Re: [PHP-DB] Problem regarding 'select...as...'
Re: Problem regarding 'select...as...'
List pgsql-sql
Tree view 
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
Attachment

pgsql-sql by date:

Previous
From: "Robert B. Easter"
Date:
Subject: Re: Outer join in postgresql
Next
From: Vince LaMonica
Date:
Subject: Re: [PHP-DB] Problem regarding 'select...as...'