Re: [HACKERS] Rules and WITH and LATERAL

2012-08-20 Thread Martijn van Oosterhout
On Sun, Aug 19, 2012 at 12:06:30PM -0400, Tom Lane wrote: While thinking about this I wondered whether it might be possible to clean up the implementation of rules, and perhaps also get rid of some of their semantic issues, by making the rule rewriter rely on WITH and/or LATERAL, neither of

[HACKERS] Rules and WITH and LATERAL

2012-08-19 Thread Tom Lane
Six years ago, we punted on allowing rules to use OLD and NEW in multi-row VALUES constructs, because we didn't have LATERAL: http://archives.postgresql.org/pgsql-hackers/2006-08/msg00044.php I thought maybe that restriction could be fixed now that we do have LATERAL, and indeed the attached