Brendan Jurd escreveu: > 2009/7/31 Euler Taveira de Oliveira <eu...@timbira.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: >>> >>> 9.99EEEE >>> 1.23E+02 >>> >> 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 compatible. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
