Jeff Davis <pg...@j-davis.com> writes: > On Tue, 2009-09-15 at 13:16 -0400, Robert Haas wrote: >> Uhh.... so what happens if I create an index constraint using the >> +(integer, integer) operator?
> You can use any operator that has an index search strategy. Overlaps is > probably the most useful, but you could imagine other operators, like a > bi-directional containment operator (either LHS is contained in RHS, or > vice-versa). Does it behave sanely for operators that are non-commutative, such as '>'? (I'm not even very sure that I know what "sanely" would be in such a case.) regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers