Re: small bug in to_char and TM prefix, in RC

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: small bug in to_char and TM prefix, in RC
Дата
Msg-id BAY20-F17DE23816A88AB98EC431FF9E40@phx.gbl
обсуждение исходный текст
Ответ на Re: small bug in to_char and TM prefix, in RC  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: small bug in to_char and TM prefix, in RC  (Martijn van Oosterhout <kleptog@svana.org>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: small bug in to_char and TM prefix, in RC
Следующее
От: Tom Lane
Дата:
Сообщение: Re: -HEAD configure issue with libedit on linux