From 0b584830f0efef400ef26da58e5c17f14cece3e7 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 25 Jun 2002 01:45:58 +0000 Subject: Update FAQ. --- doc/src/FAQ/FAQ.html | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'doc/src') diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index b6de1a6d499..3240a406850 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -14,7 +14,7 @@ alink="#0000ff">

Frequently Asked Questions (FAQ) for PostgreSQL

-

Last updated: Sun Jun 23 17:16:13 EDT 2002

+

Last updated: Mon Jun 24 21:45:50 EDT 2002

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
@@ -946,12 +946,13 @@

     SELECT col
     FROM tab
-    ORDER BY col
+    ORDER BY col [ DESC ]
     LIMIT 1
 

When using wild-card operators such as LIKE or - ~, indexes can only be used if the beginning of the search + ~, indexes can only be used if the default C local is used +during initdb and the beginning of the search is anchored to the start of the string. Therefore, to use indexes, LIKE patterns must not start with %, and ~(regular expression) patterns must start with ^.

-- cgit v1.2.3