RE: [HACKERS] ordinal decimal number - Mailing list pgsql-hackers

From Karel Zak - Zakkr
Subject RE: [HACKERS] ordinal decimal number
Date
Msg-id Pine.LNX.3.96.1000106114524.3280A-100000@ara.zf.jcu.cz
Whole thread Raw
In response to RE: [HACKERS] ordinal decimal number  ("Ansley, Michael" <Michael.Ansley@intec.co.za>)
List pgsql-hackers

On Wed, 5 Jan 2000, Ansley, Michael wrote:

> My personal opinion: ordinal numbers can get a th, rd, nd, or st.  That
> implies whole numbers only.  If an ordinal is requested, test for a positive
> integer; if not an integer, leave alone, otherwise add whichever suffix is
> required.
> 
> 2   ->    2nd
> 2.2 ->    2.2
> NaN ->    NaN
> 4   ->    4th
> -6  ->    -6

Well, it is good solution. I implement it. Or exist the other suggestion?
                        Karel



pgsql-hackers by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: [HACKERS] UdmSearch: tables vs indices ...
Next
From: Rod Chamberlin
Date:
Subject: Enhancing PGSQL to be compatible with Informix SQL