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