Re: Counting days ... - Mailing list pgsql-sql

Aarni Ruuhimäki wrote:
> So the WHERE clause would go like:
> 
> group_id = 1 AND res_start_day < '$date1' AND res_end_day >= '$date1' [AND 
> region_id = $region_id] [AND company_id = $company_id] [AND product_id = 
> $product_id]
> OR 
> group_id = 1 AND res_start_day = '$date1' AND res_end_day >= '$date1' [AND 
> region_id = $region_id] [AND company_id = $company_id] [AND product_id = 
> $product_id]
> OR
> group_id = 1 AND res_start_day >= '$date1' AND res_start_day < '$date2' AND 
> res_end_day >= '$date1' [AND region_id = $region_id] [AND company_id = 
> $company_id] [AND product_id = $product_id]


This is smaller; and should be equivalent:

group_id = 1 AND
( res_start_day <= '$date1' AND res_end_day >= '$date1'
OR
res_start_day >= '$date1' AND res_start_day < '$date2' )
[AND region_id = $region_id]
[AND company_id = $company_id]
[AND product_id =  $product_id]