Pattern matching operators a index

From: soroosh sardari <soroosh(dot)sardari(at)aut(dot)ac(dot)ir>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Pattern matching operators a index
Date: 2013-10-09 10:23:34
Message-ID: CAFUsPDZTP-eHTFqo6r49i+iAb9QxHtxPE624WMzuJrMJ-Ph1wA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

I'm developing a new type for character string, like varchar. I wrote
operators for btree and so forth.
I wonder how pattern matching operators using btree index, because btree
operator class ony knows about >, >=, <=, and = operators, but operators
for pattern matching, such as LIKE, are not known for btree access method.

Now my question is:
Is Postgre using btree for pattern matching query for varchar or other
character string types?

If it does, how i implement it for my new type?

Regards,
Soroosh

Browse pgsql-hackers by date

  From Date Subject
Next Message Soroosh Sardari 2013-10-09 10:24:12 Pattern matching operators a index
Previous Message Samrat Revagade 2013-10-09 08:54:03 Re: Patch for fail-back without fresh backup