Hi, I need to test a (user) given column type name, with one in the database for equality. To this end, I have to do some kind of normalization (e.g. 'timestamptz(2)' to 'timestamp (2) with time zone'.)
Comparing the name alone is possible with to_regtype(type_name) or ::regtype. However, this ignores the 'typemod'. I want to suggest a to_typemod(type_name) function which, combined with to_regtype, would allow to decompose (and reconstruct) a type name completely. Best, Sophie