Re: reusing column labels in select

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
>