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.
--
Michael
signature.asc
Description: PGP signature
