Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Dot YetDate: 2008-09-30 16:19:06
Subject: Re: Alias name from subquery
Previous:From: Sam MasonDate: 2008-09-30 15:23:55
Subject: Re: Alias name from subquery

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group