Re: function returning a readable representation of a number - Mailing list pgsql-general

From CoL
Subject Re: function returning a readable representation of a number
Date
Msg-id cd34sk$frr$1@news.hub.org
Whole thread Raw
In response to function returning a readable representation of a number  ("Najib Abi Fadel" <nabifadel@usj.edu.lb>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Clodoaldo Pinto Neto
Date:
Subject: Re: server closed the connection unexpectedly
Next
From: David Helgason
Date:
Subject: Re: