Horton

Re: wCTE behaviour

Yeb Havinga <yebhavinga@gmail.com>

View thread
From: Yeb Havinga <yebhavinga@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>, Hitoshi Harada <umi.tanuki@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>, David Fetter <david@fetter.org>
Date: 2010-11-14T18:51:59Z
Lists: pgsql-hackers 
On 2010-11-14 19:35, Robert Haas wrote:
> On Sun, Nov 14, 2010 at 1:01 PM, Marko Tiikkaja
> <marko.tiikkaja@cs.helsinki.fi>  wrote:
>> In my opinion, all of these should have the same effect: DELETE all rows
>> from "foo".  Any other option means we're going to have trouble predicting
>> how a query is going to behave.
> I think it's clear that's the only sensible behavior.
What if CTE's ever get input parameters?

regards,
Yeb Havinga