From e3dd4942c7112c2cf545a2c1b7da54ea2d3a729f Mon Sep 17 00:00:00 2001
From: Bruce Momjian
Date: Wed, 13 Oct 1999 02:44:23 +0000
Subject: Update for NUMERIC/DECIMAL data type.
---
doc/src/sgml/datatype.sgml | 32 ++++++++++++++++++++++----------
1 file changed, 22 insertions(+), 10 deletions(-)
(limited to 'doc/src')
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index d0d4d27c219..44dfabaa28d 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -74,6 +74,11 @@
date
calendar date without time of day
+
+ decimal
+ decimal(p,s)
+ exact numeric for p <= 9, s = 0
+
float4/8
float(p)
@@ -99,16 +104,6 @@
int, integer
signed 4-byte integer
-
- int4
- decimal(p,s)
- exact numeric for p <= 9, s = 0
-
-
- int4
- numeric(p,s)
- exact numeric for p == 9, s = 0
-
int8
@@ -129,6 +124,11 @@
decimal(9,2)
US-style currency
+
+ numeric
+ numeric(p,s)
+ exact numeric for p == 9, s = 0
+
path
@@ -282,6 +282,12 @@
+
+ decimal
+ variable
+ User-specified precision
+ no limit
+
float4
4 bytes
@@ -312,6 +318,12 @@
Very large range fixed-precision
+/- > 18 decimal places
+
+ numeric
+ variable
+ User-specified precision
+ no limit
+
serial
4 bytes
--
cgit v1.2.3