In response to Jeff Janes <jeff.ja...@gmail.com>: > On Fri, Dec 17, 2010 at 12:16 PM, Bill Moran <wmo...@potentialtech.com> wrote: > > In response to Tom Lane <t...@sss.pgh.pa.us>: > > > >> Josh Berkus <j...@agliodbs.com> writes: > >> > postgres=# select '1e+01'::Integer > >> > postgres-# ; > >> > ERROR: invalid input syntax for integer: "1e+01" > >> > >> I have never heard of any programming system anywhere that accepts such > >> a syntax for integers (assuming it distinguishes integers from other > >> numbers at all). I'm not excited about being the first. Why does this > >> error surprise you? It doesn't seem particularly different from arguing > >> that 1.000 should be considered an integer, which strikes me as a > >> seriously bad idea. > > > > But > > SELECT 1.000::Integer; > > works. And so does > > SELECT 1.234::Integer; > > 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.
Ah ... I wasn't looking carefully enough, that changes the landscape quite a bit ... -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers