Re: Alias name from subquery

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Felix Homann" <fexpop(at)onlinehome(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Alias name from subquery
Date: 2008-09-30 16:10:32
Message-ID: dcc563d10809300910j4497613cy391b6368bd09433c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Sep 30, 2008 at 8:29 AM, Felix Homann <fexpop(at)onlinehome(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dot Yet 2008-09-30 16:19:06 Re: Alias name from subquery
Previous Message Sam Mason 2008-09-30 15:23:55 Re: Alias name from subquery