Thread: reusing column labels in select

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

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@gmail.com> wrote:
> 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@postgresql.org
>

* ryan <rvanroode@gmail.com> [2004-10-16 11:18:48 -0700]:

> 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