Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199407151200.FAA25193@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Date: Fri, 15 Jul 1994 14:00:40 +0200 (MET DST)
From: Wojtek Bogusz <Wojtek.Bogusz@fuw.edu.pl>
Subject: New type and pg_operator.
To: Postgres Mailing List <postgres@postgres.Berkeley.EDU>
Message-Id: <Pine.3.89.9407151351.C21375-0100000@ccfs1>
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Fri, 15 Jul 94 05:00:39 -0700
Resent-XMts: smtp


 Hello,

 I am trying to add a new type to postgres. It is a king of char, char2,
char4, ... and text type but for different language than english. I took a
look in to pg_operators to see how they where defined :-) It is a bit
surprising for me that for all operators connected with char/text types
field oprprec (operator precedence) is equal 0. Why ?

 Does exist some (simple :-) explanation what join strategies mean ? And
why hash join strategy is defined (oprcanhash = t) just for "=" ? And why
merge-sort join strategy is not defined for all char/text operators ie. 
oprrsortop and oprlsort are equal to 0 ?

 Thank You
 Wojtek Bogusz

==============================================================================
   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.
==============================================================================