Re: function returning a readable representation of a number

From: CoL <col(at)mportal(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: function returning a readable representation of a number
Date: 2004-07-14 11:19:40
Message-ID: cd34sk$frr$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Helgason 2004-07-14 11:38:36 Re:
Previous Message elein 2004-07-14 02:23:24 Re: optimization with limit and order by in a view