Re: Nonexistent NEW relation in some places of rules - Mailing list pgsql-sql

On Tue, Jul 29, 2003 at 06:32:44PM -0400, Tom Lane wrote:
> The problem is that the rule gets expanded into something rather like
> 
>     insert into a select ... from new, produce(new.b);
> 
> and we can't support that.  If we ever add support for SQL99's
> LATERAL(), it might help improve matters.

Thanks.  I was suspecting something like.  Does the presence of this
leak mean that such a selects are needed very rarely?  Or does it mean
that some well-known workaround exists?