Rich Shepard wrote:
> A thread on the postgres users mail list asks how to write a SELECT
> statement using a column alias (e.g., SELECT emp_id AS e FROM employee),
> Bruce Momjian responded that it's not possible and on the To-Do list to not
> be done.
I've frequently used column aliases with my pg sql and never had any
problem. Do you have a reference to the thread with the original
question? Perhaps there's some subtle use that Bruce thinks doesn't
work, rather than the simple case you've illustrated?
Devin Ben-Hur 503/860-4114 mailto:devin(at)ben-hur(dot)net
"Startups are basically comedies, or at least seem so in retrospect."
-- Paul Graham
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.17.13/1209 - Release Date: 1/4/2008 12:05 PM
In response to
pdxpug by date
|Next:||From: Rich Shepard||Date: 2008-01-04 16:31:03|
|Subject: Re: Aliases for Field Names in SELECT statements|
|Previous:||From: Roth, Gabrielle||Date: 2008-01-04 15:16:48|
|Subject: Re: Call for meeting topics! Next meeting: January 17|