Re: [HACKERS] ordinal decimal number

From: Karel Zak - Zakkr <zakkr(at)zf(dot)jcu(dot)cz>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, "J(dot) Roeleveld" <j(dot)roeleveld(at)softhome(dot)net>, pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] ordinal decimal number
Date: 2000-01-05 17:49:12
Message-ID: Pine.LNX.3.96.1000105184134.23260A-100000@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2000-01-05 18:10:14 Re: ECPG documentation
Previous Message Thomas Lockhart 2000-01-05 17:30:15 Re: [HACKERS] InterBase interview on Linux Journal