On Sat, 16 Feb 2008, Ken Johanson wrote:
> Tom Lane wrote:
>
> > Hm, good point, so really we ought to have a separate casting path for
> > numeric types to char(n). However, this section still doesn't offer
> > any support for the OP's desire to auto-size the result; it says
> > that you get an error if the result doesn't fit in the declared
> > length:
> >
> >> iv) Otherwise, an exception condition is raised: data exception-
> >> string data, right truncation.
> >
>
> I don't believe the size is being declared in the OP's (subject line)
> example: SELECT CAST(123 AS char)
The other part of Tom's quotes still apply:
If length is omitted then a length of 1 is implicit.