Re: Common Table Expressions applied; some issues remain - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: Common Table Expressions applied; some issues remain
Date
Msg-id 87prmfo3cc.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Common Table Expressions applied; some issues remain  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Common Table Expressions applied; some issues remain
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:

> Tom Lane wrote:
>
>> 2. The patch didn't touch the implicit-RTE code, which means that
>>
>>     WITH q AS ( SELECT ... )
>>     SELECT q.*
>>
>> will fail even if you've got add_missing_from enabled.  I'm inclined
>> to think that this violates the principle of least surprise.  On
>> the other hand, add_missing_from is certainly a legacy thing and maybe
>> we shouldn't bother expending any extra code to make it work with
>> new features.  Thoughts?
>
> Yes, it's legacy.  I wouldn't bother.

The results would be even more suprising if there *is* a table named "q"
though...

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication
support!


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Common Table Expressions applied; some issues remain
Next
From: Tom Lane
Date:
Subject: Re: Common Table Expressions applied; some issues remain