Re: [HACKERS] ordinal decimal number

Karel Zak <zakkr@zf.jcu.cz>

From: Karel Zak - Zakkr <zakkr@zf.jcu.cz>
To: Hannu Krosing <hannu@tm.ee>
Cc: Oliver Elphick <olly@lfix.co.uk>, "J. Roeleveld" <j.roeleveld@softhome.net>, pgsql-hackers <pgsql-hackers@postgreSQL.org>
Date: 2000-01-05T17:49:12Z
Lists: pgsql-hackers
On Wed, 5 Jan 2000, Hannu Krosing wrote:

> I guess they are awkward in most languages, except for designating powers 
> where they _could_ be used by extension of their use for integer powers?
>  
> e raised to the pi-th power ?
> 
> btw, should 2.2 be 2.2nd or 2.2th (two point tooth :)
> 
> what about rationals 7 2/3 th ?
> 
> what about legal float numbers like infinity (is it infinitieth)
> and NaN - NaN-th or NaNd :)
> 
> for me 2.2nd represents not decimal but hierrachy, so it should be possible to
> have
> 2.2.2.2nd
> 
> >  I implement it to to_char (ordinal with decimal places), but is user choise
> > if use or not use it...
> 
> Is your code locale-aware ?
> 
> I guess that this is something that could probbaly be found in localisation
> tables,
> except perhaps for floats.

(IMHO) POSIX locale not contains information about ordinal numbers (if 
you mean this). But to_char supports locales for currency symbol, decimal
poin and group separator.   

							Karel