Re: function returning a readable representation of a number

From: "gnari" <gnari(at)simnet(dot)is>
To: "generalpost" <pgsql-general(at)postgresql(dot)org>
Subject: Re: function returning a readable representation of a number
Date: 2004-07-13 10:00:14
Message-ID: 001101c468c0$31a89d80$0100000a@wp2000
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From: Najib Abi Fadel
To: generalpost
Sent: Tuesday, July 13, 2004 10:07 AM
Subject: [GENERAL] function returning a readable representation of a number

> Is there any postgres function that do the following:
>
> select func(9123456789);
> 9 123 456 789

you mean like

select to_char(9123456789,'999 999 999 999');

?

gnari

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Najib Abi Fadel 2004-07-13 10:07:17 function returning a readable representation of a number
Previous Message Janko Richter 2004-07-13 09:29:15 Re: Latitude/Longitude data types and functions