Alias name from subquery

From: Felix Homann <fexpop(at)onlinehome(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Alias name from subquery
Date: 2008-09-30 13:21:53
Message-ID: 48E227F1.1050002@onlinehome.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I would like to set an alias name for a column from a subquery, i.e.
something like this:

SELECT entry AS (SELECT name from colnames WHERE id=1) from entries ;

Obviously it doesn't work _this_ way, but is there _any_ way to do it?

Kind regards,

Felix

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jörn Heid 2008-09-30 13:31:22 Standalone Windows Installation
Previous Message Andrew Sullivan 2008-09-30 13:01:30 Re: Re: Is there a parameter to tell postgresql to not attempt to open an IPv6 socket?