By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TABLE inventory (
id SERIAL PRIMARY KEY,
product VARCHAR,
quantity DECIMAL
);
INSERT INTO inventory
(product, quantity)
VALUES
('product_01', '800'),
('product_02', '300'),
('product_03', '200'),
('product_04', '500'),
('product_05', '600'),
('product_06', '400');
6 rows affected
SELECT
iv.product AS product_name,
iv.product AS 'product name'
FROM inventory iv;
ERROR: syntax error at or near "'product name'"
LINE 3: iv.product AS 'product name'
^