Обсуждение: 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');