Postgres Pro
Downloads
Home   >   mailing lists

Re: [pg_trgm] Making similarity(?, ?) < ? use an index - Mailing list pgsql-general

From Tom Lane
Subject Re: [pg_trgm] Making similarity(?, ?) < ? use an index
Date
Msg-id 13279.1465480564@sss.pgh.pa.us
Whole thread Raw
In response to Re: [pg_trgm] Making similarity(?, ?) < ? use an index  (Greg Navis <contact@gregnavis.com>)
Responses Re: [pg_trgm] Making similarity(?, ?) < ? use an index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Greg Navis <contact@gregnavis.com> 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.

            regards, tom lane

pgsql-general by date:

Previous
From: Michael McInness
Date:
Subject: Re: connection pooling, many users, many datasources
Next
From: Tom Lane
Date:
Subject: Re: [pg_trgm] Making similarity(?, ?) < ? use an index