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

From Scott Marlowe
Subject Re: Alias name from subquery
Date
Msg-id dcc563d10809300910j4497613cy391b6368bd09433c@mail.gmail.com
Whole thread Raw
In response to Re: Alias name from subquery  (Felix Homann <fexpop@onlinehome.de>)
Responses Re: Alias name from subquery  ("Dot Yet" <dot.yet@gmail.com>)
List pgsql-general
On Tue, Sep 30, 2008 at 8:29 AM, Felix Homann <fexpop@onlinehome.de> wrote:

> _But_, I don't want to give the alias explicitely, instead it should be
> taken from a second table 'colnames', i.e. something like the line I sent in
> my initial mail. Any idea?

Then you'll have to build a query in plpgsql and execute it to get
what you want.  You can't do what you're trying to do in normal SQL.
At least I don't think it's possible.

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Alias name from subquery
Next
From: "Dot Yet"
Date:
Subject: Re: Alias name from subquery