Is there a reason why the conversion from CHAR to CHAR(1) is done in
analyze.c:transformColumnType rather than right in the
grammar? Currently, you get this incorrect behaviour:
peter=# select cast('voodoo' as char(1));?column?
----------v
(1 row)
peter=# select cast('voodoo' as char);?column?
----------voodoo
(1 row)
Both should return 'v'.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/