Re: small bug in to_char and TM prefix, in RC - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: small bug in to_char and TM prefix, in RC
Date
Msg-id BAY20-F17DE23816A88AB98EC431FF9E40@phx.gbl
Whole thread Raw
In response to Re: small bug in to_char and TM prefix, in RC  (Bruce Momjian <bruce@momjian.us>)
Responses Re: small bug in to_char and TM prefix, in RC  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
Hello,

after apply my patch this bug is only visible (for czech env). Propably in 
others languages isn't used diacritic's chars in mont's and days's names. 
str_toupper is too simply and don't support UTF8, which isn't for english 
problem.

I prepare patch.

Regards
Pavel Stehule





>
>And this failure is with your translation patch applied?
>
>---------------------------------------------------------------------------
>
>Pavel Stehule wrote:
> > Hello,
> >
> > I tested TM formating with czech names. Upper case chars in name are not
> > correct. Function upper works perfectly.
> >
> > Sample:
> >
> > postgres=# select to_char(date '2006-02-03', 'TMday');
> > to_char
> > ---------
> > p�tek
> > (1 ř�dka)
> >
> > correct
> >
> > but
> >
> > postgres=# select to_char(date '2006-02-03', 'TMDAY');
> > to_char
> > ---------
> > P�TEK
> > (1 ř�dka)
> >
> > correct is P�TEK
> >
> > without spec. chars
> > wrong: PaTEK, have be: PATEK
> >
> > Regards
> > Pavel Stehule
> >
> > _________________________________________________________________
> > Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: In versions below 8.0, the planner will ignore your desire to
> >        choose an index scan if your joining column's datatypes do not
> >        match
>
>--
>   Bruce Momjian   bruce@momjian.us
>   EnterpriseDB    http://www.enterprisedb.com
>
>   + If your life is a hard drive, Christ can be your backup. +

_________________________________________________________________
Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci. 
http://messenger.msn.cz/



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: small bug in to_char and TM prefix, in RC
Next
From: Tom Lane
Date:
Subject: Re: -HEAD configure issue with libedit on linux