diff options
| -rw-r--r-- | doc/FAQ | 6 | ||||
| -rw-r--r-- | doc/src/FAQ/FAQ.html | 6 |
2 files changed, 6 insertions, 6 deletions
@@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Sun Oct 14 19:27:20 EDT 2001 + Last updated: Mon Nov 12 02:38:47 EST 2001 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -938,8 +938,8 @@ BYTEA bytea variable-length byte array (null-safe) 4.22) How do I create a column that will default to the current time? - Use now(): -CREATE TABLE test (x int, modtime timestamp DEFAULT now() ); + Use CURRENT_TIMESTAMP: +CREATE TABLE test (x int, modtime timestamp DEFAULT CURRENT_TIMESTAMP ); 4.23) Why are my subqueries using IN so slow? diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index efb5724282e..e34794f866a 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -12,7 +12,7 @@ alink="#0000FF"> <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> - <P>Last updated: Sun Oct 14 19:27:20 EDT 2001</P> + <P>Last updated: Mon Nov 12 02:38:47 EST 2001</P> <P>Current maintainer: Bruce Momjian (<A href= "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR> @@ -1202,9 +1202,9 @@ BYTEA bytea variable-length byte array (null-safe) default to the current time?<BR> </H4> - <P>Use <I>now()</I>:</P> + <P>Use <I>CURRENT_TIMESTAMP</I>:</P> <PRE> -<CODE>CREATE TABLE test (x int, modtime timestamp DEFAULT now() ); +<CODE>CREATE TABLE test (x int, modtime timestamp DEFAULT CURRENT_TIMESTAMP ); </CODE> </PRE> |