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 -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers