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. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers