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

Josh Berkus <josh@agliodbs.com> writes:
> On 12/17/10 12:46 PM, Jeff Janes wrote:
>> 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.

It's not arbitrary in the slightest.  One is a run-time type conversion;
the other is a question of what strings the type-specific input routine
for integer will accept.
        regards, tom lane