Robert Haas <robertmhaas@gmail.com> writes:
> This seems like a question for -general or some other user-focused
> mailing list, not hackers. At any rate, I don't see how 1e4 could just
> be "ignored", but as Maciek points out, 1e4 and 10000 are of different
> data types, which seems likely to be relevant somehow.
I am also wondering about careless whitespace.
postgres=# select 9/1e1;
?column?
------------------------
0.90000000000000000000
(1 row)
postgres=# select 9/1 e1;
e1
----
9
(1 row)
In any case, I tried copying-and-pasting parts of the originally
mentioned query, and I saw nothing that looked like misbehavior.
Please show an exact, self-contained test case if you want us
to believe there's a bug here.
regards, tom lane
