Re: User defined type - analyze problem - Mailing list pgsql-general

From Tom Lane
Subject Re: User defined type - analyze problem
Date
Msg-id 14418.1272894985@sss.pgh.pa.us
Whole thread Raw
In response to User defined type - analyze problem  (Carsten Kropf <ckropf2@fh-hof.de>)
Responses Re: User defined type - analyze problem  (Carsten Kropf <ckropf2@fh-hof.de>)
List pgsql-general
Carsten Kropf <ckropf2@fh-hof.de> writes:
> I read somewhere, that this can be solved by preparing a operator class for btree and passing a comparison function
forequality 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

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Re: Native DB replication for PG
Next
From: Raymond O'Donnell
Date:
Subject: Re: Native DB replication for PG