Re: Why don't we accept exponential format for integers?

On 12/17/10 12:46 PM, Jeff Janes wrote:
> 
> And so does:
> SELECT 1.23e+01::Integer
> 
> 
>> > which I find just as dangerous as
>> > SELECT '1.234e+01'::Integer;
> 
> Add quotes to either of the other two, and then they don't work either.

Well, that's stupidly arbitrary.  If we're not going to accept
'1.234e+01'::Integer, then we shouldn't accept 1.234e+01::Integer either.

--                                  -- Josh Berkus                                    PostgreSQL Experts Inc.
                        http://www.pgexperts.com