Re: [SQL] to_chat(bigint)

[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::TEXT;
or
select 
to_char(12312312312312312312::BIGINT,'fm9999999999999999999999999999999999');

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster