How to search using daterange (using gist)

[Winanjaya Amijoyo <winanjaya.amijoyo@xxxxxxxxx>]

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-05    2019-06-15        3

I need to find records based on date range, so for example:

if I search using parameters 001, 2019-01-10, 2019-02-11 .. it will found as pid 1

if I search using parameters 001, 2019-03-10, 2019-07-13 .. it will found as pid 3

but if I search out of the date range, for example:

if I search using parameters 001, 2019-07-10, 2019-09-13 .. it will not found as pid 0

how to search with the above scenario in postgresql?

please help

thanks

win