Re: citext on exclude using gist

2022-07-19 Thread David G. Johnston
On Tue, Jul 19, 2022 at 4:43 PM Tom Lane wrote: > Jean Carlo Giambastiani Lopes writes: > > 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 numr

Re: citext on exclude using gist

2022-07-19 Thread Tom Lane
Jean Carlo Giambastiani Lopes writes: > 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 w

citext on exclude using gist

2022-07-19 Thread Jean Carlo Giambastiani Lopes
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, w