|
1 |
| -<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.242 2010/02/17 04:19:37 tgl Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.243 2010/02/24 03:33:48 momjian Exp $ --> |
2 | 2 |
|
3 | 3 | <chapter id="datatype">
|
4 | 4 | <title id="datatype-title">Data Types</title>
|
@@ -715,11 +715,7 @@ NUMERIC
|
715 | 715 |
|
716 | 716 | <note>
|
717 | 717 | <para>
|
718 |
| - Prior to <productname>PostgreSQL</productname> 7.4, the precision in |
719 |
| - <type>float(<replaceable>p</replaceable>)</type> was taken to mean |
720 |
| - so many <emphasis>decimal</> digits. This has been corrected to match the SQL |
721 |
| - standard, which specifies that the precision is measured in binary |
722 |
| - digits. The assumption that <type>real</type> and |
| 718 | + The assumption that <type>real</type> and |
723 | 719 | <type>double precision</type> have exactly 24 and 53 bits in the
|
724 | 720 | mantissa respectively is correct for IEEE-standard floating point
|
725 | 721 | implementations. On non-IEEE platforms it might be off a little, but
|
@@ -795,11 +791,9 @@ ALTER SEQUENCE <replaceable class="parameter">tablename</replaceable>_<replaceab
|
795 | 791 |
|
796 | 792 | <note>
|
797 | 793 | <para>
|
798 |
| - Prior to <productname>PostgreSQL</productname> 7.3, <type>serial</type> |
799 |
| - implied <literal>UNIQUE</literal>. This is no longer automatic. If |
800 |
| - you wish a serial column to have a unique constraint or be a |
801 |
| - primary key, it must now be specified, just like |
802 |
| - any other data type. |
| 794 | + If you wish a serial column to have a unique constraint or be |
| 795 | + a primary key, it must be specified, just like any other data |
| 796 | + type. |
803 | 797 | </para>
|
804 | 798 | </note>
|
805 | 799 |
|
@@ -1521,14 +1515,6 @@ SELECT E'\\xDEADBEEF';
|
1521 | 1515 | </tgroup>
|
1522 | 1516 | </table>
|
1523 | 1517 |
|
1524 |
| - <note> |
1525 |
| - <para> |
1526 |
| - Prior to <productname>PostgreSQL</productname> 7.3, writing just |
1527 |
| - <type>timestamp</type> was equivalent to <type>timestamp with |
1528 |
| - time zone</type>. This was changed for SQL compliance. |
1529 |
| - </para> |
1530 |
| - </note> |
1531 |
| - |
1532 | 1518 | <para>
|
1533 | 1519 | <type>time</type>, <type>timestamp</type>, and
|
1534 | 1520 | <type>interval</type> accept an optional precision value
|
|
0 commit comments