Re: (Bug) Numeric fault calculation - Mailing list pgadmin-support

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