Re: Alias name from subquery

From: Felix Homann <fexpop(at)onlinehome(dot)de>
To: rod(at)iol(dot)ie
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Alias name from subquery
Date: 2008-09-30 14:42:05
Message-ID: 48E23ABD.8060006@onlinehome.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Raymond O'Donnell wrote:
> select entry from (select name from colnames where id = 1) as
> entry_with_different_name;
>
> ...maybe?

Thanks Ray!

No, "entry_with_different_name" should be the result of "SELECT name
FROM colnames WITH id=1".

Kind regards,

Felix

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2008-09-30 15:23:55 Re: Alias name from subquery
Previous Message Raymond O'Donnell 2008-09-30 14:32:09 Re: Alias name from subquery