Re: Index with new opclass not used for sorting

2019-06-21 Thread Ancoron Luciferis
On 21/06/2019 15:36, Tom Lane wrote: > Ancoron Luciferis writes: >> I am creating a new operator class for version 1 UUID's with an >> extension and thought I was almost done by implementing everything >> including SortSupport and creating a new opclass as follows: > >> CREATE OPERATOR CLASS uuid

Re: Index with new opclass not used for sorting

2019-06-21 Thread Tom Lane
Ancoron Luciferis writes: > I am creating a new operator class for version 1 UUID's with an > extension and thought I was almost done by implementing everything > including SortSupport and creating a new opclass as follows: > CREATE OPERATOR CLASS uuid_timestamp_ops FOR TYPE uuid > USING btre

Index with new opclass not used for sorting

2019-06-21 Thread Ancoron Luciferis
Hi, I am creating a new operator class for version 1 UUID's with an extension and thought I was almost done by implementing everything including SortSupport and creating a new opclass as follows: CREATE OPERATOR CLASS uuid_timestamp_ops FOR TYPE uuid USING btree AS OPERATOR1