Folks,
Is there any good reason that this works:
postgres=# select ('1e+01'::numeric)::integer
postgres-# ;int4
------ 10
But this doesn't?
postgres=# select '1e+01'::Integer
postgres-# ;
ERROR: invalid input syntax for integer: "1e+01"
LINE 1: select '1e+01'::Integer
... or did we just never implement it?
-- -- Josh Berkus PostgreSQL Experts Inc.
http://www.pgexperts.com