On Mon, Jun 26, 2017 at 8:14 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Jeevan Ladhe <jeevan.la...@enterprisedb.com> writes: > > In case of list partitioned table: > > 1. If there is a partition accepting only null values and nothing else, > then > > currently the partition constraints for such a partition are constructed > as > > "((a IS NULL) OR (a = ANY (ARRAY[]::integer[])))". > > I think there it is better to avoid constructing an empty array to avoid > > executing ANY expression. > > Looks like a good idea, pushed with trivial stylistic adjustments. > Thanks Tom for taking care of this. Regards, Jeevan Ladhe