Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit90e1ac9

Browse files
committed
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>
1 parent2a5f83c commit90e1ac9

File tree

2 files changed

+10
-2
lines changed

2 files changed

+10
-2
lines changed

‎doc/FAQ

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

22
Frequently Asked Questions (FAQ) for PostgreSQL
33

4-
Last updated:Wed Aug25 23:18:13 EDT 2004
4+
Last updated:Tue Aug31 23:28:02 EDT 2004
55

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

@@ -797,6 +797,10 @@
797797
section 4.12.
798798
* The default C locale must be used during initdb.
799799

800+
In pre-8.0 releases, indexes often can not be used unless the data
801+
types exactly match the index's column types. This is particularly
802+
true of int2, int8, and numeric column indexes.
803+
800804
4.9) How do I see how the query optimizer is evaluating my query?
801805

802806
See the EXPLAIN manual page.

‎doc/src/FAQ/FAQ.html

Lines changed: 5 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@
1010
alink="#0000ff">
1111
<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
1212

13-
<P>Last updated:Wed Aug25 23:18:13 EDT 2004</P>
13+
<P>Last updated:Tue Aug31 23:28:02 EDT 2004</P>
1414

1515
<P>Current maintainer: Bruce Momjian (<Ahref=
1616
"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>
@@ -1001,6 +1001,10 @@ <H4><A name="4.8">4.8</A>) My queries are slow or don't make use of
10011001
</UL>
10021002
<P>
10031003

1004+
<P>In pre-8.0 releases, indexes often can not be used unless the data
1005+
types exactly match the index's column types. This is particularly
1006+
true of int2, int8, and numeric column indexes.</P>
1007+
10041008
<H4><Aname="4.9">4.9</A>) How do I see how the query optimizer is
10051009
evaluating my query?</H4>
10061010

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp