Re: [HACKERS] Index scan troubles

2008-09-02 Thread Markus Wanner
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

Re: [HACKERS] Index scan troubles

2008-09-02 Thread Tom Lane
Markus Wanner <[EMAIL PROTECTED]> writes: > I'm having a hard time using an index scan. So far, I've done quite well > with ScanKeyInit for equality searches. But now I need to scan an index > from a given starting point. Something like: > (x, y, z,...) > (const, const, const,...) > For the

Re: [HACKERS] Index scan troubles

2008-09-02 Thread Gregory Stark
Markus Wanner <[EMAIL PROTECTED]> writes: > Hi, > > I'm having a hard time using an index scan. So far, I've done quite well with > ScanKeyInit for equality searches. But now I need to scan an index from a > given > starting point. Something like: > >(x, y, z,...) > (const, const, const,...)

[HACKERS] Index scan troubles

2008-09-02 Thread Markus Wanner
Hi, I'm having a hard time using an index scan. So far, I've done quite well with ScanKeyInit for equality searches. But now I need to scan an index from a given starting point. Something like: (x, y, z,...) > (const, const, const,...) For the equality operatior, I've used get_sort_group_