Re: Index scan troubles - Mailing list pgsql-hackers

From Markus Wanner
Subject Re: Index scan troubles
Date
Msg-id 48BD8CA2.7050204@bluegap.ch
Whole thread Raw
In response to Re: Index scan troubles  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Hi,

Gregory Stark wrote:
> It's right for your equality case which is effectively x=const, y=const,
> z=const. It's not for row comparisons case for which you need a funny "header"
> ScanKey. See the comments in access/skey.h, search for "row comparisons". I'm
> not sure if there's a function to create this for you or if you have to do it
> yourself. Search for other places where SK_ROW_HEADER appears.

Ah, so the default for multiple ScanKeys is 'x > const AND y > const' 
and not the row comparison. That explains my troubles. Thanks a lot.

Regards

Markus Wanner



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: WIP patch: Collation support
Next
From: Tom Lane
Date:
Subject: Re: WIP patch: Collation support