Re: pgsql: Fix rtree and contrib/rtree_gist search behavior for the 1-D box

From: Andrew - Supernews <andrew+nonews(at)supernews(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pgsql: Fix rtree and contrib/rtree_gist search behavior for the 1-D box
Date: 2005-06-24 02:26:57
Message-ID: slrndbmrrg.192v.andrew+nonews@trinity.supernews.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On 2005-06-24, Tom Lane <tgl(at)svr1(dot)postgresql(dot)org> wrote:
> Log Message:
> -----------
> Fix rtree and contrib/rtree_gist search behavior for the 1-D box and
> polygon operators (<<, &<, >>, &>). Per ideas originally put forward
> by andrew(at)supernews and later rediscovered by moi. This patch just
> fixes the existing opclasses, and does not add any new behavior as I
> proposed earlier; that can be sorted out later. In principle this
> could be back-patched, since it changes only search behavior and not
> system catalog entries nor rtree index contents. I'm not currently
> planning to do that, though, since I think it could use more testing.

Please do not backpatch this even if it tests out ok, because it will break
rtree opclasses for custom types that defined &< and &> in such a way as
to make things work with the previous code.

--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2005-06-24 02:30:45 pgsql: Completed: < * Allow REINDEX to rebuild all database indexes,
Previous Message Bruce Momjian 2005-06-24 02:07:20 pgsql: Add: > * Add program to test if fsync has a delay compared to

Browse pgsql-hackers by date

  From Date Subject
Next Message William White 2005-06-24 02:28:16 Re: Fixing r-tree semantics
Previous Message Tom Lane 2005-06-24 02:26:55 Re: Function's LEAST, GREATEST and DECODE (Oracle vararg polymorphic functions)