Re: [HACKERS] CTE inlining

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [HACKERS] CTE inlining
Дата
Msg-id 20170430074633.k2w5pvtze7ra2kto@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [HACKERS] CTE inlining  (Craig Ringer <craig.ringer@2ndquadrant.com>)
Ответы Re: [HACKERS] CTE inlining
Список pgsql-hackers
Hi,

On 2017-04-30 13:58:14 +0800, Craig Ringer wrote:
> We have OFFSET 0 for anyone really depending on it, and at least when you
> read that you know to go "wtf" and look at the manual, wheras the CTE fence
> behaviour is invisible and silent.

I don't think that's a good idea.  What if you need to prevent inlining
of something that actually needs an offset? What if the behaviour of
offset is ever supposed to change?  Relying more on that seems to just
be repeating the mistake around CTEs.


> Like the work Andes has been doing on our bizarre handing of SRFs in the
> SELECT target list I really think it's just something that needs to be
> done.

With help from Tom, luckily...

Greetings,

Andres Freund



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: [HACKERS] CTE inlining
Следующее
От: Andrew Borodin
Дата:
Сообщение: Re: [HACKERS] On How To Shorten the Steep Learning Curve Towards PG Hacking...