Re: (9.1) btree_gist support for searching on "not equals" - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: (9.1) btree_gist support for searching on "not equals"
Date
Msg-id 1279257556.861.10.camel@jdavis
Whole thread Raw
In response to Re: (9.1) btree_gist support for searching on "not equals"  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
Responses Re: (9.1) btree_gist support for searching on "not equals"
Re: (9.1) btree_gist support for searching on "not equals"
List pgsql-hackers
Hi,

Thank you for the review.

On Mon, 2010-07-12 at 17:17 +0900, Itagaki Takahiro wrote:
> (1) Exclusion constraints support for operators where "x <operator> x"
> is false (tiny patch)
> https://commitfest.postgresql.org/action/patch_view?id=307
> (2) btree_gist support for searching on <> ("not equals")
> https://commitfest.postgresql.org/action/patch_view?id=308
>
> Those patches should be committed at once because (2) requires (1) to work
> with EXCLUDE constraints. Also, (1) has no benefits without (2) because we
> have no use cases for <> as an index-able operator. Both patches are very
> simple and small, and worked as expected both "WHERE <>" and EXCLUDE
> constraints cases.

It appears that Tom already committed (1).

> I'd like to ask you to write additional documentation about btree_gist [1]
> that the module will be more useful when it is used with exclusion
> constraints together. Without documentation, no users find the usages.

Good idea, new patch attached.

Regards,
    Jeff Davis

Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: dividing money by money
Next
From: Markus Wanner
Date:
Subject: Re: imessages up-date