From: | Frank Bax <fbax(at)sympatico(dot)ca> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Counting days ... |
Date: | 2008-03-15 16:05:17 |
Message-ID: | 47DBF3BD.9080306@sympatico.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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]
From | Date | Subject | |
---|---|---|---|
Next Message | Aarni Ruuhimäki | 2008-03-15 17:06:43 | Re: Counting days ... |
Previous Message | Aarni Ruuhimäki | 2008-03-14 17:25:26 | Re: Counting days ... |