Re: function returning a readable representation of a number

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.