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: 17995.1303680816@sss.pgh.pa.us (view raw or flat)
Thread:
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
http://developer.postgresql.org/pgdocs/postgres/indexes-opclass.html
http://developer.postgresql.org/pgdocs/postgres/xindex.html
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:
http://developer.postgresql.org/pgdocs/postgres/gist.html
http://developer.postgresql.org/pgdocs/postgres/gin.html

			regards, tom lane

In response to

Responses

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-2014 The PostgreSQL Global Development Group