|
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 |
|