|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.21 2000/04/12 04:40:03 thomas Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.22 2000/04/13 07:19:27 momjian Exp $ |
3 | 3 | Postgres documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -393,21 +393,6 @@ DEFAULT <replaceable class="PARAMETER">value</replaceable> |
393 | 393 | </variablelist> |
394 | 394 | </para> |
395 | 395 |
|
396 | | - <para> |
397 | | - In the current release (v7.0), <productname>Postgres</productname> |
398 | | - evaluates all default expressions at the time the table is defined. |
399 | | - Hence, functions which are "non-cacheable" such as |
400 | | - <function>CURRENT_TIMESTAMP</function> may not produce the desired |
401 | | - effect. For the particular case of date/time types, one can work |
402 | | - around this behavior by using |
403 | | - <quote>DEFAULT TEXT 'now'</quote> |
404 | | - instead of |
405 | | - <quote>DEFAULT 'now'</quote> |
406 | | - or |
407 | | - <quote>DEFAULT CURRENT_TIMESTAMP</quote>. |
408 | | - This forces <productname>Postgres</productname> to consider the constant a string |
409 | | - type and then to convert the value to <type>timestamp</type> at runtime. |
410 | | - </para> |
411 | 396 | </refsect2> |
412 | 397 | <refsect2 id="R2-SQL-DEFAULTCLAUSE-4"> |
413 | 398 | <title> |
|