Re: [SQL] to_chat(bigint)

2007-02-02 Thread Bricklen Anderson
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::

[SQL] to_chat(bigint)

2007-02-02 Thread Ezequias Rodrigues da Rocha
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. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosam