Skip to content

Commit 0b58483

Browse files
committed
Update FAQ.
1 parent 6918df1 commit 0b58483

File tree

2 files changed

+10
-8
lines changed

2 files changed

+10
-8
lines changed

doc/FAQ

Lines changed: 6 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11

22
Frequently Asked Questions (FAQ) for PostgreSQL
33

4-
Last updated: Sun Jun 23 17:16:13 EDT 2002
4+
Last updated: Mon Jun 24 21:45:50 EDT 2002
55

66
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
77

@@ -743,13 +743,14 @@
743743
using an index with ORDER BY and LIMIT:
744744
SELECT col
745745
FROM tab
746-
ORDER BY col
746+
ORDER BY col [ DESC ]
747747
LIMIT 1
748748

749749
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 ^.
753754

754755
4.9) How do I see how the query optimizer is evaluating my query?
755756

doc/src/FAQ/FAQ.html

Lines changed: 4 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -14,7 +14,7 @@
1414
alink="#0000ff">
1515
<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
1616

17-
<P>Last updated: Sun Jun 23 17:16:13 EDT 2002</P>
17+
<P>Last updated: Mon Jun 24 21:45:50 EDT 2002</P>
1818

1919
<P>Current maintainer: Bruce Momjian (<A href=
2020
"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
946946
<PRE>
947947
SELECT col
948948
FROM tab
949-
ORDER BY col
949+
ORDER BY col [ DESC ]
950950
LIMIT 1
951951
</PRE>
952952

953953
<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
955956
is anchored to the start of the string. Therefore, to use indexes,
956957
<SMALL>LIKE</SMALL> patterns must not start with <I>%</I>, and
957958
<I>~</I>(regular expression) patterns must start with <I>^</I>.</P>

0 commit comments

Comments
 (0)