Skip site navigation (1) Skip section navigation (2)

Re: Aliases for Field Names in SELECT statements

From: Devin Ben-Hur <devin(at)ben-hur(dot)net>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pdxpug(at)postgresql(dot)org
Subject: Re: Aliases for Field Names in SELECT statements
Date: 2008-01-04 16:13:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pdxpug
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), 
> and
> 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 ShepardDate: 2008-01-04 16:31:03
Subject: Re: Aliases for Field Names in SELECT statements
Previous:From: Roth, GabrielleDate: 2008-01-04 15:16:48
Subject: Re: Call for meeting topics! Next meeting: January 17

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group