How to execlude same month and year in Postgres

Asked Mar 15 '22 at 14:01

Active Mar 15 '22 at 14:48

Viewed 27 times

short code

drop table if exists x;
create temp table x(
d date,
  exclude using gist (extract(month from d) with =,
                      extract(year from d) with =)
);

how to make this possible CREATE EXTENSION if not exists btree_gist; -- i also tried

I don't want overlapping month and year

edited Mar 15 '22 at 14:48

asked Mar 15 '22 at 14:01

Rami Jamleh

1,819
1
13
10

1

You code working as intended. What's the issue? You cannot install extension? – jian Mar 15 '22 at 14:18
it seemed i had a typing issue here or there – Rami Jamleh Mar 15 '22 at 14:27
Hmm, a regular unique index should be sufficient: `create unique index on x ( extract(year from d), extract(month from d) ) ;` – Mar 15 '22 at 15:25
@RamiJamleh What's the error message? – Bergi Mar 15 '22 at 15:53
no errors now it was a datatype thing could you please show me inline exculode clause with constraint name – Rami Jamleh Mar 15 '22 at 16:27
@RamiJamleh What's a "datatype thing"? – Bergi Mar 15 '22 at 17:09
CREATE EXTENSION if not exists btree_gist this ext deals with numbers to work with btree now it works just forget it – Rami Jamleh Mar 15 '22 at 18:14

How to execlude same month and year in Postgres

0 Answers0