Postgres 10

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 type mood as enum ('sad', 'ok', 'happy');

CREATE TYPE

select * from pg_enum;

enumtypid
enumsortorder
enumlabel

424083
1
sad

424083
2
ok

424083
3
happy

SELECT 3

select typname from pg_type where typtype='e';

typname

mood

SELECT 1

SELECT enum_range(null::mood);

enum_range

{sad,ok,happy}

SELECT 1