Received: from mail.quest.com ([192.77.210.67]) by hub.org (8.10.1/8.10.1) with SMTP id e5CMeUT40206 for ; Mon, 12 Jun 2000 18:40:36 -0400 (EDT) Received: FROM exchange.quest.com BY mail.quest.com ; Mon Jun 12 15:40:12 2000 -0700 Received: from vlamonica.quest.com ([10.1.3.82]) by exchange.quest.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id MM942BRF; Mon, 12 Jun 2000 15:40:14 -0700 Date: Mon, 12 Jun 2000 15:40:27 -0700 (PDT) From: Vince LaMonica To: Bernie Huang cc: PHP Database , PGSQL-SQL Subject: Re: [PHP-DB] Problem regarding 'select...as...' In-Reply-To: <394564F8.4B5EE3F7@ec.gc.ca> Message-ID: X-Url: http://www.quest.com/ Organization: Quest Software Inc. MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200006/127 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/