Re: [GENERAL] minimum operators for b-tree, r-tree

2004-06-30 Thread Tom Lane
elein <[EMAIL PROTECTED]> writes: > When creating a new data type, what are > the operators absolutely necessary for that > type to particpate in a btree index? You must supply all the operators described in the standard strategy set: http://www.postgresql.org/docs/7.4/static/xindex.html#XINDEX-ST

Re: [GENERAL] minimum operators for b-tree, r-tree

2004-06-29 Thread Joe Conway
elein wrote: When creating a new data type, what are the operators absolutely necessary for that type to particpate in a btree index? I know you need a "compare" that says = < or >= so does that mean that those three operators are the ones required? I don't remember the details, but here is a lin