> Adrian Klaver recommends in
Padding a text typed output with actual significant spaces "works"? It is not equivalent to a bpchar with insignificant padding spaces...
You are right. I need char(n) type and this is not working. How to use expression in cast, like
select torus(charcol) :: CHAR( ColWidth('public', 'test', 'charcol') ) from test
This throws error in Postgres. ColWidth is immutable and called with constant arguments so it should work. How to fix postgres to allow constant ColWidth() expression in cast ?
Andrus.