Postgres 12

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?.

DO $$
DECLARE
    _VARCHAR_SIZE int := 200;
BEGIN
    create table mytable(
        id int primary key,
        name varchar( _VARCHAR_SIZE )
    );
END $$;

ERROR:  syntax error at or near "_VARCHAR_SIZE"
LINE 7:         name varchar( _VARCHAR_SIZE )
                              ^


DO $$
DECLARE
    _VARCHAR_SIZE int := 200;
BEGIN
    EXECUTE format(
        'create table mytable(id int primary key, name varchar( %s ));',
        _VARCHAR_SIZE
    );
END $$;

DO


select * from mytable;


id
name



SELECT 0