Alias name from subquery - Mailing list pgsql-general

From Felix Homann
Subject Alias name from subquery
Date
Msg-id 48E227F1.1050002@onlinehome.de
Whole thread Raw
Responses Re: Alias name from subquery  (Raymond O'Donnell <rod@iol.ie>)
Re: Alias name from subquery  (Sam Mason <sam@samason.me.uk>)
List 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

pgsql-general by date:

Previous
From: Jan Otto
Date:
Subject: Re: Counting unique rows as an aggregate.
Next
From: Jörn Heid
Date:
Subject: Standalone Windows Installation