Postgres Pro
Downloads
Home   >   mailing lists

Silent truncation of numeric values. - Mailing list pgsql-general

From Rajesh Kumar Mallah
Subject Silent truncation of numeric values.
Date
Msg-id 3FBF6851.8010708@trade-india.com
Whole thread Raw
Responses Re: Silent truncation of numeric values.  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-general
Tree view

Hi,

How come numeric(10,2) accepting value 10.011 and truncating the .001
part ? Shudnt' it be complaining , i am not sure.


Regds
Mallah.


tradein_clients=# CREATE TABLE t_a ( a numeric (10,2) );
CREATE TABLE
tradein_clients=#
tradein_clients=#
tradein_clients=# \d t_a
         Table "public.t_a"
 Column |     Type      | Modifiers
--------+---------------+-----------
 a      | numeric(10,2) |

tradein_clients=# INSERT INTO t_a values(10.01);
INSERT 50817524 1
tradein_clients=# INSERT INTO t_a values(10.011);
INSERT 50817525 1
tradein_clients=#
tradein_clients=#
tradein_clients=# SELECT * from t_a;
   a
-------
 10.01
 10.01
(2 rows)

tradein_clients=#

pgsql-general by date:

Previous
From: "Markus Seibold"
Date:
Subject: Open source data modeling tools for PostgreSQL
Next
From: "Carmen Wai"
Date:
Subject: Invalid page header in block xxxx