Re: to_chat(bigint) - Mailing list pgsql-sql

Ezequias Rodrigues da Rocha wrote:
> Hi list,
> 
> Now I noticed that it is impossible to convert a bigint field to char 
> with the function to_char. Is it correct ?
> 
> If not please tell me how to convert a bigint using to_char.
> 
Couple ways I can see immedately:

select 123123123123123123123::BIGINT::TEXT;
or
select 
to_char(12312312312312312312::BIGINT,'fm9999999999999999999999999999999999');