diff options
| author | Bruce Momjian <bruce@momjian.us> | 2004-09-01 03:28:15 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2004-09-01 03:28:15 +0000 |
| commit | 90e1ac92929e456fc7750d81cd6517f6dd1c1370 (patch) | |
| tree | 8abd975626b0903a549867742689f2c4a77b7bda | |
| parent | 2a5f83c17c1938f9a10176580b339b13c4f40c0d (diff) | |
| download | postgresql-90e1ac92929e456fc7750d81cd6517f6dd1c1370.tar.gz postgresql-90e1ac92929e456fc7750d81cd6517f6dd1c1370.zip | |
Add index mention:
<P>In pre-8.0 releases, indexes often can not be used unless the data
types exactly match the index's column types. This is particularly
true of int2, int8, and numeric column indexes.</P>
| -rw-r--r-- | doc/FAQ | 6 | ||||
| -rw-r--r-- | doc/src/FAQ/FAQ.html | 6 |
2 files changed, 10 insertions, 2 deletions
@@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Wed Aug 25 23:18:13 EDT 2004 + Last updated: Tue Aug 31 23:28:02 EDT 2004 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -797,6 +797,10 @@ section 4.12. * The default C locale must be used during initdb. + In pre-8.0 releases, indexes often can not be used unless the data + types exactly match the index's column types. This is particularly + true of int2, int8, and numeric column indexes. + 4.9) How do I see how the query optimizer is evaluating my query? See the EXPLAIN manual page. diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 37e4c969c52..47c00659bc6 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff"> <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> - <P>Last updated: Wed Aug 25 23:18:13 EDT 2004</P> + <P>Last updated: Tue Aug 31 23:28:02 EDT 2004</P> <P>Current maintainer: Bruce Momjian (<A href= "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR> @@ -1001,6 +1001,10 @@ </UL> <P> + <P>In pre-8.0 releases, indexes often can not be used unless the data + types exactly match the index's column types. This is particularly + true of int2, int8, and numeric column indexes.</P> + <H4><A name="4.9">4.9</A>) How do I see how the query optimizer is evaluating my query?</H4> |