I wrote: > Greg Navis <contact@xxxxxxxxxxxxx> writes: >> I'm not sure how to make this operator use an index. It seems I need to >> create an operator class but I'm not sure how. > What you'd want to do is add it to the existing operator class and then > teach the class's support functions (mostly, the "consistent" function) > about it. BTW, you'd probably find this patch instructive: https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=f576b17cd6ba653bdace1f0da9a3b57f4984e460 although it's doing more than just adding one operator. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
