Re: [var]char versus character [varying]

2020-10-23 Thread Tom Lane
James Coleman writes: > I've been wondering recently why the external canonical form of types > like char and varchar doesn't match the typname in pg_type. Mostly because the SQL standard wants certain spellings, some of which aren't even single words (e.g. DOUBLE PRECISION). There are cases whe

[var]char versus character [varying]

2020-10-23 Thread James Coleman
I've been wondering recently why the external canonical form of types like char and varchar doesn't match the typname in pg_type. Additionally, the alternative/extended names are hardcoded in format_type.c rather than being an additional column in that catalog table. I would have assumed there wer