reusing column labels in select

From: rvanroode(at)gmail(dot)com (ryan)
To: pgsql-general(at)postgresql(dot)org
Subject: reusing column labels in select
Date: 2004-10-16 18:18:48
Message-ID: 84ad9273.0410161018.657edbc1@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lint Hasenpfeffer 2004-10-16 21:20:21 Re: OS X Install
Previous Message Ken Tozier 2004-10-16 17:50:37 Newbie table definition question