Commit0b58483

committed

Update FAQ.

1 parent6918df1 commit0b58483Copy full SHA for 0b58483

File tree

+10

-8

lines changed

+10

-8

lines changed

Lines changed: 6 additions & 5 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 Jun23 17:16:13 EDT 2002`
	`4`	`+ Last updated:Mon Jun24 21:45:50 EDT 2002`
`5`	`5`
`6`	`6`	`Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)`
`7`	`7`
`@@ -743,13 +743,14 @@`
`743`	`743`	`using an index with ORDER BY and LIMIT:`
`744`	`744`	`SELECT col`
`745`	`745`	`FROM tab`
`746`		`- ORDER BY col`
	`746`	`+ ORDER BY col [ DESC ]`
`747`	`747`	`LIMIT 1`
`748`	`748`
`749`	`749`	`When using wild-card operators such as LIKE or ~, indexes can only be`
`750`		`- used if the beginning of the search is anchored to the start of the`
`751`		`- string. Therefore, to use indexes, LIKE patterns must not start with`
`752`		`- %, and ~(regular expression) patterns must start with ^.`
	`750`	`+ used if the default C local is used during initdb and the beginning of`
	`751`	`+ the search is anchored to the start of the string. Therefore, to use`
	`752`	`+ indexes, LIKE patterns must not start with %, and ~(regular`
	`753`	`+ expression) patterns must start with ^.`
`753`	`754`
`754`	`755`	`4.9) How do I see how the query optimizer is evaluating my query?`
`755`	`756`

Lines changed: 4 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -14,7 +14,7 @@`
`14`	`14`	`alink="#0000ff">`
`15`	`15`	`<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>`
`16`	`16`
`17`		`-<P>Last updated:Sun Jun23 17:16:13 EDT 2002</P>`
	`17`	`+<P>Last updated:Mon Jun24 21:45:50 EDT 2002</P>`
`18`	`18`
`19`	`19`	`<P>Current maintainer: Bruce Momjian (<Ahref=`
`20`	`20`	`"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>`
`@@ -946,12 +946,13 @@ <H4><A name="4.8">4.8</A>) My queries are slow or don't make use of`
`946`	`946`	`<PRE>`
`947`	`947`	`SELECT col`
`948`	`948`	`FROM tab`
`949`		`- ORDER BY col`
	`949`	`+ ORDER BY col [ DESC ]`
`950`	`950`	`LIMIT 1`
`951`	`951`	`</PRE>`
`952`	`952`
`953`	`953`	`<P>When using wild-card operators such as<SMALL>LIKE</SMALL> or`
`954`		`-<I>~</I>, indexes can only be used if the beginning of the search`
	`954`	`+<I>~</I>, indexes can only be used if the default C local is used`
	`955`	`+during initdb and the beginning of the search`
`955`	`956`	`is anchored to the start of the string. Therefore, to use indexes,`
`956`	`957`	`<SMALL>LIKE</SMALL> patterns must not start with<I>%</I>, and`
`957`	`958`	`<I>~</I>(regular expression) patterns must start with<I>^</I>.</P>`

Comments

(0)