Re: Alias name from subquery - Mailing list pgsql-general

From Sam Mason
Subject Re: Alias name from subquery
Date
Msg-id 20080930152355.GO7271@frubble.xen.chris-lamb.co.uk
Whole thread Raw
In response to Alias name from subquery  (Felix Homann <fexpop@onlinehome.de>)
Responses Re: Alias name from subquery  (Felix Homann <fexpop@onlinehome.de>)
List pgsql-general
On Tue, Sep 30, 2008 at 03:21:53PM +0200, Felix Homann wrote:
> 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?

Generate the SQL correctly in the first place? :)

I think you may be trying to solve the wrong problem, what are you
really trying to do?


  Sam

pgsql-general by date:

Previous
From: Felix Homann
Date:
Subject: Re: Alias name from subquery
Next
From: "Scott Marlowe"
Date:
Subject: Re: Alias name from subquery