From: Vince LaMonica <Vince.LaMonica@quest.com>
To: Bernie Huang <bernie.huang@ec.gc.ca>
Cc: PHP Database <php-db@lists.php.net>
Cc: PGSQL-SQL <pgsql-sql@postgresql.org>
Subject: Re: [PHP-DB] Problem regarding 'select...as...'
Date: Mon, 12 Jun 2000 15:40:27 -0700 (PDT)
Message-ID: <Pine.WNT.4.21.0006121539160.256-100000@vlamonica.quest.com> (raw)
In-Reply-To: <394564F8.4B5EE3F7@ec.gc.ca>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: Vince.LaMonica@quest.com, bernie.huang@ec.gc.ca, php-db@lists.php.net
Subject: Re: [PHP-DB] Problem regarding 'select...as...'
In-Reply-To: <Pine.WNT.4.21.0006121539160.256-100000@vlamonica.quest.com>
References: <394564F8.4B5EE3F7@ec.gc.ca> <Pine.WNT.4.21.0006121539160.256-100000@vlamonica.quest.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox