Re: Problem regarding 'select...as...'

From: Jesus Aneiros <aneiros(at)jagua(dot)cfg(dot)sld(dot)cu>
To: Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca>
Cc: PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Problem regarding 'select...as...'
Date: 2000-06-13 05:18:43
Message-ID: Pine.LNX.4.10.10006130117100.9993-100000@jagua.cfg.sld.cu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Mack 2000-06-13 07:23:08 Re: postmaster: init.d/start
Previous Message GANESH KUMAR 2000-06-13 04:43:18 sql foregein key