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
