Raul Chirea <[EMAIL PROTECTED]> writes:
> So, it seems to be a parser difficulty (bug) to correctly determine
> the type of a numeric constant with decimals (like 99.9).
Yes. You can find more about this in the pgsql-hackers archives.
We've been aware of the problem for a while but are unsure as yet
how to solve it without breaking other cases --- ie, cases where
you *do* want such a constant to be treated as float not numeric.
For the moment, we have left the behavior as it's always been in
Postgres (ie, undecorated non-integral constants are taken to be
'float8'), so as not to break existing applications.
regards, tom lane
