Re: select single entry and its neighbours using direct-acess to index?

>>     I thought the planner had an automatic rewriter for these situations.
>
> No.  There was a prior discussion of this, saying that we really ought
> to support the SQL-spec row comparison syntax:

    What I meant was that I thought the planner could rewrite :
    (A and C) or (A AND B) as A and (B or C)
    which is more index-friendly.

>     ... WHERE (name, name2) > ('b', 'a');
> which would map directly onto the semantics of a 2-column index.  We
> don't have that functionality yet, though (we take the syntax but the
> semantics are not SQL-compliant) let alone any ability to pass it
> through to a 2-column index.

    One could always use ARRAY[name,name2] > ARRAY['b','a']
    But it is NOT index-friendly...