operators and indices?

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: operators and indices?
Date: 2001-05-18 00:58:11
Message-ID: Pine.BSO.4.10.10105172051110.20890-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message mlw 2001-05-18 01:31:59 Re: Plans for solving the VACUUM problem
Previous Message Mike Mascari 2001-05-18 00:52:51 RE: Plans for solving the VACUUM problem