diff options
| author | Bruce Momjian <bruce@momjian.us> | 1999-10-13 02:44:23 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 1999-10-13 02:44:23 +0000 |
| commit | e3dd4942c7112c2cf545a2c1b7da54ea2d3a729f (patch) | |
| tree | 420c58fd8b1b7b2162a1562a1fecb0fee607ac6d | |
| parent | 7ee7ee1398acb2ba8e1738a4d959025e43df8820 (diff) | |
| download | postgresql-e3dd4942c7112c2cf545a2c1b7da54ea2d3a729f.tar.gz postgresql-e3dd4942c7112c2cf545a2c1b7da54ea2d3a729f.zip | |
Update for NUMERIC/DECIMAL data type.
| -rw-r--r-- | doc/src/sgml/datatype.sgml | 32 |
1 files changed, 22 insertions, 10 deletions
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 @@ -75,6 +75,11 @@ <entry>calendar date without time of day</entry> </row> <row> + <entry>decimal</entry> + <entry>decimal(p,s)</entry> + <entry>exact numeric for p <= 9, s = 0</entry> + </row> + <row> <entry>float4/8</entry> <entry>float(p)</entry> <entry>floating-point number with precision p</entry> @@ -100,16 +105,6 @@ <entry>signed 4-byte integer</entry> </row> <row> - <entry>int4</entry> - <entry>decimal(p,s)</entry> - <entry>exact numeric for p <= 9, s = 0</entry> - </row> - <row> - <entry>int4</entry> - <entry>numeric(p,s)</entry> - <entry>exact numeric for p == 9, s = 0</entry> - </row> - <row> <entry>int8</entry> <entry></entry> <entry>signed 8-byte integer</entry> @@ -130,6 +125,11 @@ <entry>US-style currency</entry> </row> <row> + <entry>numeric</entry> + <entry>numeric(p,s)</entry> + <entry>exact numeric for p == 9, s = 0</entry> + </row> + <row> <entry>path</entry> <entry></entry> <entry>open and closed geometric path in 2D plane</entry> @@ -283,6 +283,12 @@ </thead> <tbody> <row> + <entry>decimal</entry> + <entry>variable</entry> + <entry>User-specified precision</entry> + <entry>no limit</entry> + </row> + <row> <entry>float4</entry> <entry>4 bytes</entry> <entry>Variable-precision</entry> @@ -313,6 +319,12 @@ <entry>+/- > 18 decimal places</entry> </row> <row> + <entry>numeric</entry> + <entry>variable</entry> + <entry>User-specified precision</entry> + <entry>no limit</entry> + </row> + <row> <entry>serial</entry> <entry>4 bytes</entry> <entry>Identifer or cross-reference</entry> |