operators and indices? - Mailing list pgsql-hackers

From Alex Pilosov
Subject operators and indices?
Date
Msg-id Pine.BSO.4.10.10105172051110.20890-100000@spider.pilosoft.com
Whole thread Raw
Responses Re: operators and indices?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hello,

I've noticed that all custom operators or inet type (such as <<, <<=, etc)  
cannot use an index, even though it is possible to define such an
operation on an index, for ex:
X << Y can be translated to "X >= network(Y) && X <= broadcast(Y)" (or so)

According to docs, postgres has hard-coded the ops which match index types
(such as btree for <,>,=, etc and rtree for @, etc). Is there a better way
than hardcoding support for inet types into index-selection code?

-alex



pgsql-hackers by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Plans for solving the VACUUM problem
Next
From: Mike Mascari
Date:
Subject: RE: Plans for solving the VACUUM problem