Brendan Jurd escreveu:
> 2009/7/31 Euler Taveira de Oliveira <euler(at)timbira(dot)com>:
>> Brendan Jurd escreveu:
>>> Limiting to two exponent digits also has the nice property that the
>>> output always matches the length of the format pattern:
>> I don't think neglecting to represent a valid number is a "nice property".
>> What does the length of format pattern have to do with output format?
> Most of the format patterns in to_char() are chosen to match the
> length of their expected output. The output of "DD" is two
> characters, "Mon" is three and so on.
Brendan, the main point of to_*() functions is Oracle-compatibility. So let's
just do it. No matter it seems bizarre (like 999.99EEEE).
> That's why the scientific notation pattern is "EEEE" and not just "E".
I don't know. Ask Oracle. ;) We don't need to bother with that. Let's just be
Euler Taveira de Oliveira
In response to
pgsql-hackers by date
|Next:||From: Joe Conway||Date: 2009-07-30 17:02:11|
|Subject: Re: CommitFest Status Summary - 2009-07-25|
|Previous:||From: Tom Lane||Date: 2009-07-30 16:46:43|
|Subject: Re: WIP: to_char, support for EEEE format |