Re: Exponential notation bug

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