Silent truncation of numeric values.

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Silent truncation of numeric values.
Date: 2003-11-22 13:44:49
Message-ID: 3FBF6851.8010708@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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=#

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2003-11-22 14:22:35 Re: Multiuser testing -- PostgreSQL 7.3.4
Previous Message Markus Seibold 2003-11-22 10:48:35 Open source data modeling tools for PostgreSQL