On 30/09/2008 14:21, Felix Homann wrote:
> I would like to set an alias name for a column from a subquery, i.e. > something like this: > > SELECT entry AS (SELECT name from colnames WHERE id=1) from entries ; select entry from (select name from colnames where id = 1) as entry_with_different_name; ...maybe? Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
