citext on exclude using gist - Mailing list pgsql-general

From Jean Carlo Giambastiani Lopes
Subject citext on exclude using gist
Date
Msg-id DM8PR16MB44858A184A49F3A7076D51D6BA8F9@DM8PR16MB4485.namprd16.prod.outlook.com
Whole thread Raw
Responses Re: citext on exclude using gist  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

I'm trying to use a citext column in the following manner without success:

create extension btree_gist;
create extension citext;
create table my_table(
    foo citext,
    bar numrange,
    primary key (foo, bar),
    exclude using gist (foo with =, bar with &&)
);

is this possible? If so, what's wrong on this snippet?


Regards,
Jean Lopes

pgsql-general by date:

Previous
From: Gavan Schneider
Date:
Subject: Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence
Next
From: Tom Lane
Date:
Subject: Re: citext on exclude using gist