Problem regarding 'select...as...'

From: Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca>
To: PHP Database <php-db(at)lists(dot)php(dot)net>, PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Problem regarding 'select...as...'
Date: 2000-06-12 22:32:25
Message-ID: 394564F8.4B5EE3F7@ec.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 Content-Type Size
bernie.huang.vcf text/x-vcard 315 bytes

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Vince LaMonica 2000-06-12 22:40:27 Re: [PHP-DB] Problem regarding 'select...as...'
Previous Message Robert B. Easter 2000-06-12 21:53:48 Re: Outer join in postgresql