Re: Bugs in to_char function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: trogers3(at)creigh(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org, Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
Subject: Re: Bugs in to_char function
Date: 2000-10-18 03:40:44
Message-ID: 3724.971840444@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches

"Tom Rogers" <trogers3(at)creigh(dot)com> writes:
> [to_char] gives the correct meridian value for all AM times but incorrectly
> returns an AM meridian for PM times between 12:00 PM and 1:50:59 PM.

I believe this is a known bug in the 7.0 implementation of to_char, and
is long since fixed in development sources. Karel Zak is the author of
to_char and would know for sure. Karel, does it make sense to
back-patch a quick fix for this into REL7_0_PATCHES for the upcoming
7.0.3 release? If so, could you provide a patch?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Lockhart 2000-10-18 05:18:08 Re: UPPER and LOWER dosen't work correctly on special caracters (umlauts)
Previous Message Peter Eisentraut 2000-10-17 21:06:05 Re: Field Separator setting not used.

Browse pgsql-patches by date

  From Date Subject
Next Message Karel Zak 2000-10-18 08:21:32 Re: Bugs in to_char function
Previous Message Lennert Buytenhek 2000-10-17 23:32:32 [PATCH] allow specifying allowed user in 'trust' hba entries