Thread: to_chat(bigint)

Hi list,<br /><br />Now I noticed that it is impossible to convert a bigint field to char with the function to_char. Is
itcorrect ?<br /><br />If not please tell me how to convert a bigint using to_char.<br clear="all" /><br />-- <br />
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=<br/>                                  Atenciosamente
(Sincerely)<br/>                        Ezequias Rodrigues da Rocha<br />
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é melhor do
quea melhor das ditaduras<br />The worst of democracies is still better than the better of dictatorships<br /><a
href="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a> 

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');