Re: Default operator class for data type boolean for access method gist is missing

From: Emre Hasegeli <emre(at)hasegeli(dot)com>
To: Andreas Joseph Krogh <andreak(at)officenet(dot)no>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Default operator class for data type boolean for access method gist is missing
Date: 2014-03-23 07:13:43
Message-ID: CAE2gYzxCBA4nKw5PAbx-eGZ=p5_U9NJgUOj7sQZHtzdi=dNgYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2014-03-23, Andreas Joseph Krogh <andreak(at)officenet(dot)no>:

> I'm trying to define the following exclusion-constraint
>
>
> *alter table *my_table *add EXCLUDE USING gist *(is_default *WITH *=, *daterange*(valid_from, valid_to, *'[)'*) *WITH *&&) *WHERE *(is_default = *true*);
>
> is_default should not be in the index as only one
value filtered on the WHERE clause.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2014-03-23 08:59:27 Re: Default operator class for data type boolean for access method gist is missing
Previous Message Andreas Joseph Krogh 2014-03-23 00:20:28 Default operator class for data type boolean for access method gist is missing