Обсуждение: function returning a readable representation of a number

Nope.

You can create one though.

Mike

On Tue, Jul 13, 2004 at 12:07:17PM +0200, Najib Abi Fadel wrote:
> 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
numbersby spaces. 
>
> Thx

hi,

Najib Abi Fadel wrote:
>
> 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.

you can write it for your own, but here is one:
http://gear.hu/files/resources/postgresql/number_format.sql

C.