Re: BUG #11526: WITH tables not accessible from function - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #11526: WITH tables not accessible from function
Date
Msg-id 20607.1412109989@sss.pgh.pa.us
Whole thread Raw
In response to BUG #11526: WITH tables not accessible from function  (bryan@unhwildhats.com)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #11528: Max Index Keys
Next
From: Paul Dasari
Date:
Subject: Re: BUG #11528: Max Index Keys