Re: Cannot query views with WHERE clause on renamed columns

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Cannot query views with WHERE clause on renamed columns
Дата
Msg-id 24334.1404169196@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Cannot query views with WHERE clause on renamed columns  (Alexander Reichstadt <lxr@mac.com>)
Список pgsql-general
Дерево обсуждения 
Alexander Reichstadt <lxr@mac.com> writes:
> I try to do what seems to be totally simple, but it fails. If I query a view that contains renamed columns without
anyqualifier like 

> SELECT * FROM myview

> it displays everything. If however I do

> SELECT reanmedviewcolumn FROM myview

> It tells me column does not exist which in fact does.

What do you mean by a "renamed column"?  A concrete example would help
here.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: Cannot query views with WHERE clause on renamed columns
Следующее
От: "frank ernest"
Дата:
Сообщение: how to create multiple databases running in different dirs