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." David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Bug-Numeric-fault-calculation-tp5752984p5759768.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
