The function format_type() fails only for interval when used on the interval type
template1=# select format_type(oid, typlen) from pg_type; ERROR: invalid INTERVAL typmod: 0xc template1=# select format_type(oid, typlen) from pg_type where typname != 'interval'; -- Many results ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend