Re: User defined type - analyze problem

Поиск
Список
Период
Сортировка
От Carsten Kropf
Тема Re: User defined type - analyze problem
Дата
Msg-id DA8FADCC-9A62-44A9-BFE1-F2570F2654BF@fh-hof.de
обсуждение исходный текст
Ответ на Re: User defined type - analyze problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Thanks a lot, this helped me with the messages. I thought, I would only have to define a operator class that fullfills
atleast the equals strategy. I didn't know, that I would have to provide a "full" btree operator class. 

Best regards
    Carsten Kropf
Am 03.05.2010 um 15:56 schrieb Tom Lane:

> 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
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


В списке pgsql-general по дате отправления:

Предыдущее
От: AI Rumman
Дата:
Сообщение: Re: SSL error
Следующее
От: Ray Stell
Дата:
Сообщение: Re: SSL error