Re: WIP: to_char, support for EEEE format - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: WIP: to_char, support for EEEE format
Date
Msg-id 162867790908101232x303f6e3axcd0c56bdb4f40c40@mail.gmail.com
Whole thread Raw
In response to Re: WIP: to_char, support for EEEE format  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: WIP: to_char, support for EEEE format  (Brendan Jurd <direvus@gmail.com>)
List pgsql-hackers
2009/8/10 Tom Lane <tgl@sss.pgh.pa.us>:
> Brendan Jurd <direvus@gmail.com> writes:
>> Here's version 7.
>
> Applied with a couple of corrections: the numeric case wasn't dealing
> with NaNs in the same way as the float cases, and the int8 case was
> converting to float8 which would lose precision.  I made it go through
> numeric instead, which is pretty expensive but I doubt this is worth
> expending extra code on.
>
>                        regards, tom lane
>

It's nice. I am playing with it, and now I found some potential issue.
The parser is maybe too tolerant:

postgres=# select to_char(3.14323,'9.9(aaaaaEEEE');to_char
---------- 3.1e+00
(1 row)

regards
Pavel Stehule


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: PL/Perl crash when using threaded perl
Next
From: "Kevin Grittner"
Date:
Subject: Re: Patch for 8.5, transformationHook