Re: How to search using daterange (using gist)

2019-05-16 Thread Andreas Kretschmer
Am 16.05.19 um 11:57 schrieb Winanjaya Amijoyo: Hi All, I have records as below that I inserted using exclusion gist constraint user_id    start_date      end_date         pid 001          2019-01-01    2019-02-10        1 001          2019-02-01    2019-03-12        2 001          2019-03-0

How to search using daterange (using gist)

2019-05-16 Thread Winanjaya Amijoyo
Hi All, I have records as below that I inserted using exclusion gist constraint user_idstart_date end_date pid 001 2019-01-012019-02-101 001 2019-02-012019-03-122 001 2019-03-052019-06-153 I need to find records base