stored proc - how to format numbers?

From: "J(dot)V(dot)" <jvsrvcs(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: stored proc - how to format numbers?
Date: 2011-09-21 18:36:02
Message-ID: 4E7A2E92.7030904@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2011-09-21 18:45:07 Re: stored proc - how to format numbers?
Previous Message hamann.w 2011-09-21 15:59:49 looking for a faster way to do that