"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> I guess where I got confused is:
>>
>> http://www.postgresql.org/docs/8.1/static/indexes-multicolumn.html
>>
>> And explicitly:
>>
>> A multicolumn B-tree index can be used with query conditions that
>> involve any subset of the index's columns, but the index is most
>> efficient when there are constraints on the leading (leftmost) columns.
> Considering the paragraph from the documentation above, should we change
> the documentation?
That statement seems perfectly accurate to me.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
