On Fri, 4 Sep 2020 at 20:21, Yang, Rong wrote:
> in OSS 10, how to make the top plan of the plan tree to GatherMerge with
> ‘except all’ in sql?
(I guess you're talking about PostgreSQL 10. I'm not sure what OSS 10 is.)
The ability for Gather Merge to work with Init Plan values was only
added
Hello~
When I look at the plan for a query in OSS11 and OSS10, the plan tree structure
is different.
OSS10.13:
postgres=# explain (costs off) select C,((select c_int from table1 where
C<=2)except all(select c_int from table1 where C=2)) from table1 where C < 100
order by C;
