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). You can also get creative and have a "similarity" operator that determines whether two tuples are "too similar". As long as it is symmetric, the feature will work. Or just use wrap random() in an operator and see what happens ;) Regards, Jeff Davis -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers