| 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 ... |