Re: SELECT CAST(123 AS char) -> 1

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)