UUID datatype and GIST index support

From: Misa Simic <misa(dot)simic(at)gmail(dot)com>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: UUID datatype and GIST index support
Date: 2011-08-19 12:17:47
Message-ID: CAH3i69maGfWiySwnAvxnQNbEWhRVn0fUyNboZNVkuZUDfvudUA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is there maybe GIST support patch for UUID datatype?

I do not it it concretly just for UUID column... it is more because of I
need it in EXCLUDE constraint...

CREATE TABLE test_exclude
{
id serial NOT NULL,
guid uuid NOT NULL,
valid_period period NOT NULL,
CONSTRAINT "test_excludepk" PRIMARY KEY (id),
EXCLUDE USING gist (guid WITH =. valid_period WITH &&) --for the same guid,
period must not overlap...

}

Thanks,

Misa

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Perepelica 2011-08-19 12:25:47 Re: synchronous_standby_names with '*'
Previous Message Fujii Masao 2011-08-19 11:48:13 Re: synchronous_standby_names with '*'