|
74 | 74 | <entry>date</entry> |
75 | 75 | <entry>calendar date without time of day</entry> |
76 | 76 | </row> |
| 77 | + <row> |
| 78 | + <entry>decimal</entry> |
| 79 | + <entry>decimal(p,s)</entry> |
| 80 | + <entry>exact numeric for p <= 9, s = 0</entry> |
| 81 | + </row> |
77 | 82 | <row> |
78 | 83 | <entry>float4/8</entry> |
79 | 84 | <entry>float(p)</entry> |
|
99 | 104 | <entry>int, integer</entry> |
100 | 105 | <entry>signed 4-byte integer</entry> |
101 | 106 | </row> |
102 | | - <row> |
103 | | - <entry>int4</entry> |
104 | | - <entry>decimal(p,s)</entry> |
105 | | - <entry>exact numeric for p <= 9, s = 0</entry> |
106 | | - </row> |
107 | | - <row> |
108 | | - <entry>int4</entry> |
109 | | - <entry>numeric(p,s)</entry> |
110 | | - <entry>exact numeric for p == 9, s = 0</entry> |
111 | | - </row> |
112 | 107 | <row> |
113 | 108 | <entry>int8</entry> |
114 | 109 | <entry></entry> |
|
129 | 124 | <entry>decimal(9,2)</entry> |
130 | 125 | <entry>US-style currency</entry> |
131 | 126 | </row> |
| 127 | + <row> |
| 128 | + <entry>numeric</entry> |
| 129 | + <entry>numeric(p,s)</entry> |
| 130 | + <entry>exact numeric for p == 9, s = 0</entry> |
| 131 | + </row> |
132 | 132 | <row> |
133 | 133 | <entry>path</entry> |
134 | 134 | <entry></entry> |
|
282 | 282 | </row> |
283 | 283 | </thead> |
284 | 284 | <tbody> |
| 285 | + <row> |
| 286 | +<entry>decimal</entry> |
| 287 | +<entry>variable</entry> |
| 288 | +<entry>User-specified precision</entry> |
| 289 | +<entry>no limit</entry> |
| 290 | + </row> |
285 | 291 | <row> |
286 | 292 | <entry>float4</entry> |
287 | 293 | <entry>4 bytes</entry> |
|
312 | 318 | <entry>Very large range fixed-precision</entry> |
313 | 319 | <entry>+/- > 18 decimal places</entry> |
314 | 320 | </row> |
| 321 | + <row> |
| 322 | +<entry>numeric</entry> |
| 323 | +<entry>variable</entry> |
| 324 | +<entry>User-specified precision</entry> |
| 325 | +<entry>no limit</entry> |
| 326 | + </row> |
315 | 327 | <row> |
316 | 328 | <entry>serial</entry> |
317 | 329 | <entry>4 bytes</entry> |
|