Postgres Pro
Downloads
Home   >   mailing lists

Re: Why don't we accept exponential format for integers? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Why don't we accept exponential format for integers?
Date
Msg-id 16251.1292624537@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why don't we accept exponential format for integers?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Why don't we accept exponential format for integers?
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: psql expanded auto
Next
From: Marti Raudsepp
Date:
Subject: Re: Why don't we accept exponential format for integers?