Tom Lane wrote:
Simply that a commonly used database (my) does not support it.
They do support char(n) in this context, which would have the advantage
of being standards compliant as well as de-facto portable.
Hmm, interesting. Mysql actual returns:
select cast(123 AS char(10)) -> '123' (agreed wrong since length is
explicit)
And PG (Ms also) gives:
select cast(123 AS char(10)) -> '123 ' (tested via jdbc driver since
hard to visualize the space in psql)
and PG:
select '='||cast(123 AS char(10))||'=' -> '=123=' (test via psql)
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
