On 21/09/2011 19:36, J.V. wrote: > 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. You're looking for to_char(): http://www.postgresql.org/docs/9.1/static/functions-formatting.html Something like this ought to do what you want: select to_char(12345678, 'FM999,999,990'); Each 9 in the formatting pattern will output a digit only if there's a corresponding one in the number; and the FM trims off any padding spaces. Just make sure you have enough 9s in the pattern for any possible number you'll encounter. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
