Robert Haas <[email protected]> writes:
> On Sun, Nov 14, 2010 at 1:51 PM, Yeb Havinga <[email protected]> wrote:
>> What if CTE's ever get input parameters?
> Then they'd be functions, which we already have.
If you mean something like
prepare foo(int) as
with x as (delete from tab where id = $1 returning *)
insert into log_table select * from x;
I don't see that the parameter makes things any less well-defined.
If you mean a parameter in the sense of an executor parameter passed
in from a surrounding nestloop, that'd scare me too --- but I thought
we were going to disallow wCTEs except at the top level of a query,
so the case wouldn't arise.
regards, tom lane
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
