Re: BUG #11526: WITH tables not accessible from function

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #11526: WITH tables not accessible from function
Дата
Msg-id 20607.1412109989@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #11526: WITH tables not accessible from function  (bryan@unhwildhats.com)
Список pgsql-bugs
bryan@unhwildhats.com writes:
> I need to access a temporary table created by a WITH statement in a function
> called from the subsequent SELECT. I could not find any documentation
> forbidding this behavior.

You're imagining that a WITH clause creates an actual table.  It does not,
any more than, say, a function call in the FROM clause does.  It's just
a name accessible within the query the WITH is attached to.  Sorry.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #11528: Max Index Keys
Следующее
От: Paul Dasari
Дата:
Сообщение: Re: BUG #11528: Max Index Keys