Hi,
I have tried more on this, if you just use an equality constraint on the
foreign key in the right side of the join, it works. Other constraints like
between, in, >,< do not work. Anyone else got to achieve this in postgresql?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/transitive-pruning-optimization-on-the-right-side-of-a-join-for-partition-tables-tp5726019p5728401.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.