Re: Aliases for Field Names in SELECT statements

>>>>> "Rich" == Rich Shepard <rshepard(at)appl-ecosys(dot)com> writes:

Rich> A thread on the postgres users mail list asks how to write a SELECT
Rich> statement using a column alias (e.g., SELECT emp_id AS e FROM employee),
Rich> and Bruce Momjian responded that it's not possible and on the To-Do list
Rich> to not be done.

Are you sure he wasn't talking about the fact that in the standard, aliases
apply *after* the WHERE, but *before* the HAVING, and therefore you can't ever
use aliases in the WHERE clause since they simply don't exist yet?

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn(at)stonehenge(dot)com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!