Re: [PHP-DB] Problem regarding 'select...as...' - Mailing list pgsql-sql

From Vince LaMonica
Subject Re: [PHP-DB] Problem regarding 'select...as...'
Date
Msg-id Pine.WNT.4.21.0006121539160.256-100000@vlamonica.quest.com
Whole thread Raw
In response to Problem regarding 'select...as...'  (Bernie Huang <bernie.huang@ec.gc.ca>)
List pgsql-sql
On 2000-06-12, Bernie Huang stated:

} "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

Try: "select equip_attr[1] as year, equip_attr[2] as make"
instead.

HTH,

/vjl/



pgsql-sql by date:

Previous
From: Bernie Huang
Date:
Subject: Problem regarding 'select...as...'
Next
From: Alex
Date:
Subject: Simple search question