can't reproduce example

From: herve(at)duchesne(dot)me
To: pgsql-docs(at)postgresql(dot)org
Subject: can't reproduce example
Date: 2017-09-22 15:03:33
Message-ID: 20170922150333.1448.70668@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.5/static/rangetypes.html
Description:

I tried to reproduce the example :
CREATE EXTENSION btree_gist;
CREATE TABLE room_reservation (
room text,
during tsrange,
EXCLUDE USING GIST (room WITH =, during WITH &&)
);

but I got this error :
ERROR: data type text 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.

That means by default nobody is able to reproduce your example... Howto use
gist with text or varchar?

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2017-09-22 15:47:19 Re: can't reproduce example
Previous Message Michael Paquier 2017-09-21 00:54:28 Re: CREATE GROUP: REPLICATION, NOREPLICATION, BYPASSRLS, NOBYPASSRLS, CONNECTION LIMIT connlimit