Re: Alias name from subquery

Hi Jeffrey,

Thanks for your quick response!

Hoover, Jeffrey wrote:
>
> select (SELECT name from colnames WHERE id=1) as entry from entries;
>

I think, I should have been a bit clearer in what I need:

I've got two tables, colnames and entries:

test=# SELECT * from colnames;
id | name
----+------
1 | col1
(1 row)

test=# SELECT entry from entries;
entry
--------
first
second
third
(3 rows)

I would like to get the column name "entry" replaced by an alias "col1",
just like this:

test=# SELECT entry as col1 from entries;
col1
--------
first
second
third
(3 rows)

_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?

Thanks again,

Felix

BTW, here's what I get from your command:

test=# select (SELECT name from colnames WHERE id=1) as entry from entries;
entry
-------
col1
col1
col1
(3 rows)