Re: Index scan troubles

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