PostgreSQL - Table Partitioning
Consider this setup:
What will this query return?
CREATE TABLE sales (id INT, year INT, region TEXT) PARTITION BY RANGE (year) SUBPARTITION BY LIST (region);
CREATE TABLE sales_2022 PARTITION OF sales FOR VALUES FROM (2022) TO (2023) SUBPARTITION BY LIST (region);
CREATE TABLE sales_2022_eu PARTITION OF sales_2022 FOR VALUES IN ('EU');
INSERT INTO sales VALUES (101, 2022, 'EU');
What will this query return?
SELECT * FROM sales WHERE year = 2022 AND region = 'EU';