Re: why doesn't optimizer can pull up where a > ( ... )

[Daniel Gustafsson]

> On 20 Nov 2019, at 13:15, Andy Fan <zhihui.fan1...@gmail.com> wrote:

> 2.  why pg can't do it,  while greenplum can? 

It's worth noting that Greenplum, the example you're referring to, is using a
completely different query planner, and different planners have different
characteristics and capabilities.

cheers ./daniel