Home > mailing lists

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

From	Najib Abi Fadel
Subject	function returning a readable representation of a number
Date	July 13, 2004 09:10:04
Msg-id	003a01c468c1$3083fe30$f664a8c0@najib Whole thread Raw
Responses	Re: function returning a readable representation of a number Re: function returning a readable representation of a number
List	pgsql-general

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.

Thx

From: ljb
Date: 13 July 2004, 01:29:44
Subject: Re: change the last bit

From: Janko Richter
Date: 13 July 2004, 09:29:25
Subject: Re: Latitude/Longitude data types and functions