diff options
| author | Bruce Momjian <bruce@momjian.us> | 2001-11-12 07:38:57 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2001-11-12 07:38:57 +0000 |
| commit | 905109f24a49caed336ffe15f8191be440c42305 (patch) | |
| tree | e38b3d1790b1ad8ed094a9073b96c253d9f4b006 | |
| parent | 0954ea174aa4896fc103e6ead94ffb4d680751dd (diff) | |
| download | postgresql-905109f24a49caed336ffe15f8191be440c42305.tar.gz postgresql-905109f24a49caed336ffe15f8191be440c42305.zip | |
Update FAQ.
| -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> |