citext on exclude using gist

From: Jean Carlo Giambastiani Lopes <jean(dot)lopes(at)hotmail(dot)com(dot)br>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: citext on exclude using gist
Date: 2022-07-19 23:31:08
Message-ID: DM8PR16MB44858A184A49F3A7076D51D6BA8F9@DM8PR16MB4485.namprd16.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2022-07-19 23:43:23 Re: citext on exclude using gist
Previous Message Gavan Schneider 2022-07-19 22:10:18 Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence