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

From Alvaro Herrera
Subject Re: WIP: to_char, support for EEEE format
Date
Msg-id 20090810174201.GD4796@alvh.no-ip.org
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  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: WIP: to_char, support for EEEE format
Next
From: Tom Lane
Date:
Subject: Re: machine-readable explain output v4