function returning a readable representation of a number

From: "Najib Abi Fadel" <nabifadel(at)usj(dot)edu(dot)lb>
To: "generalpost" <pgsql-general(at)postgresql(dot)org>
Subject: function returning a readable representation of a number
Date: 2004-07-13 10:07:17
Message-ID: 003a01c468c1$3083fe30$f664a8c0@najib
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there any postgres function that do the following:

select func(9123456789);
9 123 456 789

the function is given a number and it returns a "readable" string representation of the number seperating groups of 3 numbers by spaces.

Thx

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Constantin Khatsckevich 2004-07-13 11:29:58 varchar length... PHP
Previous Message gnari 2004-07-13 10:00:14 Re: function returning a readable representation of a number