Skip site navigation (1) Skip section navigation (2)

Re: Ordinal suffix behaviour

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Daniel Baldoni <dbaldoni(at)iinet(dot)net(dot)au>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Ordinal suffix behaviour
Date: 2000-06-09 03:18:10
Message-ID: 200006090318.XAA06731@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Applied.  Thanks.


> G'day folks,
> 
> The enclosed patch changes the behaviour of the "ordinal" ('TH') format for
> to_char.  I don't know about the rest of the world, but the "standard" in
> Australia is the following:
> 
> 	1st, 2nd, 3rd, 4th - 9th
> 	10th - 19th
> 	21st, 22nd, 23rd, 24th - 29th (similarly for 30s - 90s)
> 	110th - 119th (and for all "teens")
> 	121st, 122nd, 123rd, 124th - 129th
> 
> I think you see the trend.  The current code works fine except that it
> produces:
> 
> 	111st, 112nd, 113rd, 114th - 119th
> 	211st, 212nd, 213rd, 214th - 219th ... and so on.
> 
> Without knowing anything about what's supported (and what isn't) in the usual
> I18N libraries, should this type of behaviour be defined within the locales?
> 
> *** src/backend/utils/adt/formatting.c.orig	Fri Jun  9 04:33:30 2000
> --- src/backend/utils/adt/formatting.c	Fri Jun  9 04:35:48 2000
> ***************
> *** 1258,1271 ****
>   get_th(char *num, int type)
>   {
>   	int			len = strlen(num),
> ! 				last;
>   
>   	last = *(num + (len - 1));
>   	if (!isdigit((unsigned char) last))
>   		elog(ERROR, "get_th: '%s' is not number.", num);
>   
> ! 	/* 11 || 12 */
> ! 	if (len == 2 && (last == '1' || last == '2') && *num == '1')
>   		last = 0;
>   
>   	switch (last)
> --- 1258,1274 ----
>   get_th(char *num, int type)
>   {
>   	int			len = strlen(num),
> ! 				last, seclast;
>   
>   	last = *(num + (len - 1));
>   	if (!isdigit((unsigned char) last))
>   		elog(ERROR, "get_th: '%s' is not number.", num);
>   
> ! 	/*
> ! 	 * All "teens" (<x>1[0-9]) get 'TH/th',
> ! 	 * while <x>[02-9][123] still get 'ST/st', 'ND/nd', 'RD/rd', respectively
> ! 	 */
> ! 	if ((len > 1) && ((seclast = num[len-2]) == '1'))
>   		last = 0;
>   
>   	switch (last)
> 
> 
> 
> -------------------------------------------------------+---------------------
> Daniel Baldoni BAppSc, PGradDipCompSci                 |  Technical Director
> require 'std/disclaimer.pl'                            |  LcdS Pty. Ltd.
> -------------------------------------------------------+  856B Canning Hwy
> Phone/FAX:  +61-8-9364-8171                            |  Applecross
> Mobile:     041-888-9794                               |  WA 6153
> URL:        http://www.lcds.com.au/                    |  Australia
> -------------------------------------------------------+---------------------
> "Any time there's something so ridiculous that no rational systems programmer
>  would even consider trying it, they send for me."; paraphrased from "King Of
>  The Murgos" by David Eddings.  (I'm not good, just crazy)
> 


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-patches by date

Next:From: Chris BitmeadDate: 2000-06-09 11:18:35
Subject: Re: MY PATCH
Previous:From: Peter EisentrautDate: 2000-06-09 00:57:36
Subject: Re: BeOS Files & diff's

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group