Re: User defined type - analyze problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Carsten Kropf <ckropf2(at)fh-hof(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: User defined type - analyze problem
Date: 2010-05-03 13:56:25
Message-ID: 14418.1272894985@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Carsten Kropf <ckropf2(at)fh-hof(dot)de> writes:
> I read somewhere, that this can be solved by preparing a operator class for btree and passing a comparison function for equality there. I did this with the following lines:
> CREATE OPERATOR CLASS pointnd_btree_class
> DEFAULT FOR TYPE pointnd USING btree AS
> OPERATOR 3 =(pointnd, pointnd)
> ;

You need an actual, usable btree operator class, not one-sixth of one ...
this is lacking the other four operators and the support function.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2010-05-03 15:15:29 Re: Am I supposed to be all scared of compound primary keys?
Previous Message Gauthier, Dave 2010-05-03 13:29:16 Re: Native DB replication for PG