Feature request

Поиск
Список
Период
Сортировка
Искать
От
Scott Miller
Тема
Feature request
Дата
в 15:06:41
Msg-id
76bb504a0805020834o1b91413al3464f45fe170f0c5@mail.gmail.com
Список
Дерево обсуждения
Feature request "Scott Miller" <smiller@duels.com>
Re: Feature request Tom Lane <tgl@sss.pgh.pa.us>
Re: Feature request "Scott Marlowe" <scott.marlowe@gmail.com>
Re: Feature request "Scott Miller" <smiller@duels.com>
One problem I've had in development recently is the inability to get the aliased name of a table from a query.  We're using a PHP framework for querying, which internally uses pg_field_name to retrieve the select list field name, which is great.  There is alwo pg_table_name, to retrieve the table the field originated from.  The problem is that this returns the name of the table, unaliased.  If a query does a self join, you can't retrieve a distinguishing table alias name for that field.  For example:

SELECT a.mycolumn, b.mycolumn
   FROM mytable a, mytable b
  WHERE ...

If I controlled query generation at all times, I could simply alias a.mycolumn and b.mycolumn differently in the select list.  But if for example this is SELECT * FROM, those columns are indistinguishable.

Cheers,
  Scott
В списке pgsql-general по дате отправления
От: Javier Olazaguirre
Дата:
Сообщение: Speed up repetitive queries
От: tekwiz
Дата:
FAQ