Skip site navigation (1) Skip section navigation (2)

Re: operator classes for index?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: weissig(at)rbg(dot)informatik(dot)tu-darmstadt(dot)de
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: operator classes for index?
Date: 2011-04-24 21:33:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
=?ISO-8859-15?Q?Yves_Wei=DFig?= <weissig(at)rbg(dot)informatik(dot)tu-darmstadt(dot)de> writes:
> again index access methods, can somebody shed some light into operator
> classes for indexes? The documentation is an entry point, but after
> reading I still don't have a clue how exactly they are used and created?
> Perhaps somebody with great knowledge can supply an 101 on opeartor
> classes? Because I keep getting the hint: You must specify an operator
> class for the index or define a default operator class for the data type.

Have you read
and the reference pages for CREATE OPERATOR CLASS/FAMILY?

If it's still not coming together for you, there are numerous examples
of creating operator classes in the contrib modules.  The GIST and GIN
documentation might be relevant as well:

			regards, tom lane

In response to


pgsql-hackers by date

Next:From: Tom LaneDate: 2011-04-24 21:46:55
Subject: Re: Extension Packaging
Previous:From: Tom LaneDate: 2011-04-24 21:27:50
Subject: Re: Unlogged tables, persistent kind

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group