I have a query that is not returning the desired results. I want the results to be a list of permit_id's held between 2 dates, but the results I'm getting is only those permit_id's that start on date_from ('27-06-02') and finish on date_to ('11-07-02'), I also want the permit_id's returned for those permits that are held within that time period, for example a permit that starts on 20-06-02 and finishes on 04-07-02. I've tried all sorts of variations but I'm still not getting the right results, anyone have any ideas?
WHERE person_id = (select person_id from person where person_id = 100)
AND cancel_permit is null
AND location = 'Kent Forest'
AND ( (date_from >= '27-06-02' AND date_to <= '11-07-02')
OR (date_from <= '27-06-02' AND date_to >= '11-07-02') )
ORDER BY permit_id ;
(Please note that this query is being used in a Java application and the values shown here are examples)
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2002-06-26 23:11:52|
|Subject: Re: Can't get pg_hba.conf to work |
|Previous:||From: Doug Silver||Date: 2002-06-26 18:20:59|
|Subject: Can't get pg_hba.conf to work|