Re: uuids with btree_gist

Поиск
Список
Период
Сортировка
От Joe Van Dyk
Тема Re: uuids with btree_gist
Дата
Msg-id CACfv+pKE1V_7BJVY7tSa6Cu3fS6vyd1dM0h2MHbQyLAT+qhO6w@mail.gmail.com
обсуждение исходный текст
Ответ на uuids with btree_gist  (Martin Renters <martin@datafax.com>)
Список pgsql-general
On Tue, Sep 3, 2013 at 1:41 PM, Martin Renters <martin@datafax.com> wrote:
I'm trying to use timestamp ranges to keep track of the values particular items had over time, but I'm unable to create a table as follows:

test=# create extension btree_gist;
CREATE EXTENSION
test=# create table v(item uuid, lifetime tstzrange, value text,
test(# exclude using gist (item with =, lifetime with &&));
ERROR:  data type uuid has no default operator class for access method "gist"
HINT:  You must specify an operator class for the index or define a default operator class for the data type.
test=#

It works fine if I make item a text field.

test=# create table v(item text, lifetime tstzrange, value text,
test(# exclude using gist (item with =, lifetime with &&));
CREATE TABLE
test=#

Is there any reason that the required uuid access method isn't implemented?  How hard is it to implement this?

I would also like to see btree_gist support uuid's. 

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: store multiple rows with the SELECT INTO statement
Следующее
От: Gudmundur Johannesson
Дата:
Сообщение: Re: Generic function for partitioning function?