Tom Lane escribió:
> Also, I'm wondering what should happen with
>
> regression=# select to_char(0.000485, '99.99EEEE');
> to_char
> -----------
> 4.85e-04
> (1 row)
>
> Doesn't seem quite right. Should we throw error if the number of 9's
> before the decimal point isn't 1?
No, see
http://archives.postgresql.org/message-id/4A68FAE4.50206@timbira.com
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support