diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-05-01 15:54:46 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-05-01 15:54:46 +0000 |
| commit | 768eaf14163fb89d4c2b395cbf4a5eb016d0c0b3 (patch) | |
| tree | 4a3eaa28f8c7e8fab24fe6c211a4481881cba3ef /doc/src | |
| parent | 628c0893fdcdb63b7079af5358536486a7764ac2 (diff) | |
| download | postgresql-768eaf14163fb89d4c2b395cbf4a5eb016d0c0b3.tar.gz postgresql-768eaf14163fb89d4c2b395cbf4a5eb016d0c0b3.zip | |
Mention the actual stored size of NUMERIC values, per David Fetter.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/datatype.sgml | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 5ca2ab2f61b..06183ec9e76 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.156 2005/03/13 09:36:30 neilc Exp $ +$PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.157 2005/05/01 15:54:46 tgl Exp $ --> <chapter id="datatype"> @@ -505,7 +505,9 @@ NUMERIC trailing zeroes. Thus, the declared precision and scale of a column are maximums, not fixed allocations. (In this sense the <type>numeric</> type is more akin to <type>varchar(<replaceable>n</>)</type> - than to <type>char(<replaceable>n</>)</type>.) + than to <type>char(<replaceable>n</>)</type>.) The actual storage + requirement is two bytes for each group of four decimal digits, + plus eight bytes overhead. </para> <para> |