agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Wolf-D. Ihlenfeldt <wolf@molout.tutkie.tut.ac.jp>
To: postgres@postgres.Berkeley.EDU
Subject: How to interface hash access to user types
Date: Thu, 14 Jul 94 20:19:56 jst
Message-ID: <9407141119.AA12463@molout.tutkie.tut.ac.jp> (raw)


he Postgres 4.2 documentation explains in detail
how to interface user data types to btree access methods
but seems to be completely silent about introducing a
hash access method for a user data type. Does anybody
know the necessary steps ? 
Details: I need to access unsigned 64 bit integers. I have
a comprehensive set of functions for this type, and I 
was able to define a btree access for this type. However,
I always retrieve with the '=' operator and therefore
a hash access to these numbers (which are hashcodes themselves)
might be mor effective. Currently I fail with 
WARN:Jul 14 20:30:13:IndexCatalogInformation: no amop 405 65504 1
in the query
(dbxtool) print query
`wb_dbwrite`db_write_prepare`query = "retrieve (Molecules.oid) where Molecules.E_HASHY="5F25E412BAC38683"::uint8"

with an (unprepared) hash index on the E_HASHY field.

Thank you for your help.

WDI


==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: wolf@molout.tutkie.tut.ac.jp
  Subject: Re: How to interface hash access to user types
  In-Reply-To: <9407141119.AA12463@molout.tutkie.tut.ac.jp>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox