reusing column labels in select - Mailing list pgsql-general

From rvanroode@gmail.com (ryan)
Subject reusing column labels in select
Date
Msg-id 84ad9273.0410161018.657edbc1@posting.google.com
Whole thread Raw
Responses Re: reusing column labels in select  (Kevin Barnard <kevin.barnard@gmail.com>)
Re: reusing column labels in select  (Steven Klassen <sklassen@commandprompt.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Josh Close
Date:
Subject: how much ram do i give postgres?
Next
From: Barry S
Date:
Subject: Re: Change query priority