uuids with btree_gist

Поиск
Список
Период
Сортировка
От Martin Renters
Тема uuids with btree_gist
Дата
Msg-id C59F2565-4753-4C83-BDCD-A0F9430B1638@datafax.com
обсуждение исходный текст
Ответы Re: uuids with btree_gist  (Joe Van Dyk <joe@tanga.com>)
Список pgsql-general
I'm trying to use timestamp ranges to keep track of the values particular items had over time, but I'm unable to create
atable 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?

Thanks,

Martin



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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: store multiple rows with the SELECT INTO statement
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: store multiple rows with the SELECT INTO statement