From 5eaa271b77858c5ce01c87c8bd36359fd7dc58f3 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 13 Apr 2000 07:19:27 +0000 Subject: [PATCH] No longer need to cast default non-cacheable functions. --- doc/src/sgml/ref/create_table.sgml | 17 +---------------- 1 file changed, 1 insertion(+), 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 @@ @@ -393,21 +393,6 @@ DEFAULT value - - In the current release (v7.0), Postgres - evaluates all default expressions at the time the table is defined. - Hence, functions which are "non-cacheable" such as - CURRENT_TIMESTAMP may not produce the desired - effect. For the particular case of date/time types, one can work - around this behavior by using - DEFAULT TEXT 'now' - instead of - DEFAULT 'now' - or - DEFAULT CURRENT_TIMESTAMP. - This forces Postgres to consider the constant a string - type and then to convert the value to timestamp at runtime. - -- 2.39.5