diff options
| author | Bruce Momjian <bruce@momjian.us> | 2000-04-13 07:19:27 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2000-04-13 07:19:27 +0000 |
| commit | 5eaa271b77858c5ce01c87c8bd36359fd7dc58f3 (patch) | |
| tree | 96daf90764c63fece3aeb4d81f43106312cf6f60 | |
| parent | 97580f69934d76d9e6ef1c87a0f9704d11c26f54 (diff) | |
No longer need to cast default non-cacheable functions.
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 17 |
1 files changed, 1 insertions, 16 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 0e4642e912c..9bc0968a439 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.21 2000/04/12 04:40:03 thomas Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.22 2000/04/13 07:19:27 momjian Exp $ Postgres documentation --> @@ -393,21 +393,6 @@ DEFAULT <replaceable class="PARAMETER">value</replaceable> </variablelist> </para> - <para> - In the current release (v7.0), <productname>Postgres</productname> - evaluates all default expressions at the time the table is defined. - Hence, functions which are "non-cacheable" such as - <function>CURRENT_TIMESTAMP</function> may not produce the desired - effect. For the particular case of date/time types, one can work - around this behavior by using - <quote>DEFAULT TEXT 'now'</quote> - instead of - <quote>DEFAULT 'now'</quote> - or - <quote>DEFAULT CURRENT_TIMESTAMP</quote>. - This forces <productname>Postgres</productname> to consider the constant a string - type and then to convert the value to <type>timestamp</type> at runtime. - </para> </refsect2> <refsect2 id="R2-SQL-DEFAULTCLAUSE-4"> <title> |