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 t (
id int,
geom geometry(point) NOT NULL DEFAULT 'POINT EMPTY'
);
CREATE TABLE
INSERT INTO t (id) VALUES (1),(2);
INSERT 0 2
SELECT * FROM t;
| id | geom |
|---|---|
| 1 | 0101000000000000000000F87F000000000000F87F |
| 2 | 0101000000000000000000F87F000000000000F87F |
SELECT 2
SELECT
'POINT EMPTY'::geometry,
'POLYGON EMPTY'::geometry,
'LINESTRING EMPTY'::geometry,
'MULTILINESTRING EMPTY'::geometry,
'MULTIPOLYGON EMPTY'::geometry,
'MULTIPOINT EMPTY'::geometry,
'POLYHEDRALSURFACE EMPTY'::geometry,
'TRIANGLE EMPTY'::geometry,
'TIN EMPTY'::geometry,
'GEOMETRYCOLLECTION EMPTY'::geometry;
| geometry | geometry | geometry | geometry | geometry | geometry | geometry | geometry | geometry | geometry |
|---|---|---|---|---|---|---|---|---|---|
| 0101000000000000000000F87F000000000000F87F | 010300000000000000 | 010200000000000000 | 010500000000000000 | 010600000000000000 | 010400000000000000 | 010F00000000000000 | 011100000000000000 | 011000000000000000 | 010700000000000000 |
SELECT 1