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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
