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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers