stored proc - how to format numbers? - Mailing list pgsql-general

From J.V.
Subject stored proc - how to format numbers?
Date
Msg-id 4E7A2E92.7030904@gmail.com
Whole thread Raw
Responses Re: stored proc - how to format numbers?
List pgsql-general
In PostgreSQL (9.x), I have a variable that I want to format with commas.

I do not know how many digits will be in the number, it could be an int
(2Billion+) or a BigInt (18 digits or more).

All I simply want to do is to use:  to_number( and have the commas put
in before display.

There are no example of this in the documentation that I could find.

thanks

J.C.

pgsql-general by date:

Previous
From: hamann.w@t-online.de
Date:
Subject: looking for a faster way to do that
Next
From: Raymond O'Donnell
Date:
Subject: Re: stored proc - how to format numbers?