Commit905109f

committed

Update FAQ.

1 parent0954ea1 commit905109fCopy full SHA for 905109f

File tree

-6

lines changed

-6

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,7 +1,7 @@`
`1`	`1`
`2`	`2`	`Frequently Asked Questions (FAQ) for PostgreSQL`
`3`	`3`
`4`		`- Last updated:Sun Oct 14 19:27:20 EDT 2001`
	`4`	`+ Last updated:Mon Nov 12 02:38:47 EST 2001`
`5`	`5`
`6`	`6`	`Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)`
`7`	`7`
`@@ -938,8 +938,8 @@ BYTEA bytea variable-length byte array (null-safe)`
`938`	`938`
`939`	`939`	`4.22) How do I create a column that will default to the current time?`
`940`	`940`
`941`		`- Usenow():`
`942`		`-CREATE TABLE test (x int, modtime timestamp DEFAULTnow() );`
	`941`	`+ UseCURRENT_TIMESTAMP:`
	`942`	`+CREATE TABLE test (x int, modtime timestamp DEFAULTCURRENT_TIMESTAMP );`
`943`	`943`
`944`	`944`	`4.23) Why are my subqueries using IN so slow?`
`945`	`945`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -12,7 +12,7 @@`
`12`	`12`	`alink="#0000FF">`
`13`	`13`	`<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>`
`14`	`14`
`15`		`-<P>Last updated:Sun Oct 14 19:27:20 EDT 2001</P>`
	`15`	`+<P>Last updated:Mon Nov 12 02:38:47 EST 2001</P>`
`16`	`16`
`17`	`17`	`<P>Current maintainer: Bruce Momjian (<Ahref=`
`18`	`18`	`"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>`
`@@ -1202,9 +1202,9 @@ <H4><A name="4.22">4.22</A>) How do I create a column that will`
`1202`	`1202`	`default to the current time?<BR>`
`1203`	`1203`	`</H4>`
`1204`	`1204`
`1205`		`-<P>Use<I>now()</I>:</P>`
	`1205`	`+<P>Use<I>CURRENT_TIMESTAMP</I>:</P>`
`1206`	`1206`	`<PRE>`
`1207`		`-<CODE>CREATE TABLE test (x int, modtime timestamp DEFAULTnow() );`
	`1207`	`+<CODE>CREATE TABLE test (x int, modtime timestamp DEFAULTCURRENT_TIMESTAMP );`
`1208`	`1208`	`</CODE>`
`1209`	`1209`	`</PRE>`
`1210`	`1210`

Comments

(0)