Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select 1e3;

?column?

1000

select pg_typeof(1e3);

pg_typeof

numeric

select 1.332e-4;

?column?

0.0001332

select pg_typeof(1.332e-4);

pg_typeof

numeric

select -0.3872e-2;

?column?

-0.003872