Re: (Bug) Numeric fault calculation

On Tue, 2013-06-18 at 15:30 -0700, David Johnston wrote:
> Guillaume Lelarge-3 wrote
> > If you use a floating
> > point datatype (which is what happens when you don't specificy the
> > type),
>
> I covered this in my prior post but per the documentation this is incorrect.
>
> http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS
>
> 4.1.2.6. Numeric Constants
>
> "Constants that contain decimal points and/or exponents are always initially
> presumed to be type numeric."
>

postgres=# select pg_typeof(260739.94);
pg_typeof
-----------
numeric
(1 row)

Seems you're right. Sorry.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com