On Tue, Sep 24, 2019 at 11:14 AM Michael Paquier <mich...@paquier.xyz> wrote: > On Tue, Sep 24, 2019 at 10:52:30AM +0900, Amit Langote wrote: > > As of v12, Append node is elided when there's a single subnode under > > it. An example in the partitioning documentation needs to be fixed to > > account for that change. Attached a patch. > > Indeed, using the same example as the docs: > CREATE TABLE measurement ( > logdate date not null, > peaktemp int, > unitsales int > ) PARTITION BY RANGE (logdate); > CREATE TABLE measurement_y2016m07 > PARTITION OF measurement ( > unitsales DEFAULT 0 > ) FOR VALUES FROM ('2016-07-01') TO ('2016-08-01'); > SET enable_partition_pruning = on; > EXPLAIN SELECT count(*) FROM measurement WHERE logdate = DATE > '2016-07-02'; > > I'll take care of committing that, however this will have to wait > until v12 RC1 is tagged.
Sure, thank you. Regards, Amit