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

From David Johnston
Subject Re: (Bug) Numeric fault calculation
Date
Msg-id 1371594619733-5759768.post@n5.nabble.com
Whole thread Raw
In response to Re: (Bug) Numeric fault calculation  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: (Bug) Numeric fault calculation
List pgadmin-support
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.



pgadmin-support by date:

Previous
From: David Johnston
Date:
Subject: Re: (Bug) Numeric fault calculation
Next
From: David Johnston
Date:
Subject: Re: (Bug) Numeric fault calculation