Postgres Pro
Downloads
Home   >   mailing lists

Re: Bugs in to_char function - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bugs in to_char function
Date
Msg-id 3724.971840444@sss.pgh.pa.us
Whole thread Raw
In response to Bugs in to_char function  ("Tom Rogers" <trogers3@creigh.com>)
Responses Re: Bugs in to_char function
List pgsql-bugs
Tree view 
"Tom Rogers" <trogers3@creigh.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

pgsql-bugs by date:

Previous
From: Ilya Goldberg
Date:
Subject: OID in WHERE clause of SELECT results in error
Next
From: Thomas Lockhart
Date:
Subject: Re: UPPER and LOWER dosen't work correctly on special caracters (umlauts)