reusing column labels in select

#1

Hello,

Is there any way to reuse a column label in a select list like this:

SELECT 1 + 1 AS a, a + 1 AS b;

I vaguely remember being able to do something like this in oracle. Any
ideas? Thanks!

~RvR

#2

There might be a better way then this but this works

SELECT a, a+1 as b from (SELECT 1+1 as a) as ab;

On 16 Oct 2004 11:18:48 -0700, ryan <rvanroode (AT) gmail (DOT) com> wrote:

Quote:

Hello,

Is there any way to reuse a column label in a select list like this:

SELECT 1 + 1 AS a, a + 1 AS b;

I vaguely remember being able to do something like this in oracle. Any
ideas? Thanks!

~RvR

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

#3

* ryan <rvanroode (AT) gmail (DOT) com> [2004-10-16 11:18:48 -0700]:

Quote:

Is there any way to reuse a column label in a select list like this:

SELECT 1 + 1 AS a, a + 1 AS b;

I vaguely remember being able to do something like this in oracle. Any
ideas? Thanks!

You could nest them...

xinu=> select (1 + 1) + 1 as answer;
answer
--------
3
(1 row)

--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

reusing column labels in select

comp.databases.postgresql.general comp.databases.postgresql.general

reusing column labels in select - 10-16-2004 , 01:18 PM

Re: reusing column labels in select - 10-19-2004 , 05:16 PM

Re: reusing column labels in select - 10-19-2004 , 05:18 PM