From: | Niklas Johansson <spot(at)tele2(dot)se> |
---|---|
To: | Jonathan Sinclair <jonathan(dot)sinclair(at)molevalleyfarmers(dot)com> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: |
Date: | 2006-08-10 23:30:45 |
Message-ID: | 7D3E0D83-0581-43CF-A767-91F184203064@tele2.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On 4 aug 2006, at 08.55, Jonathan Sinclair wrote:
> SELECT field1, SUM(field2) as Field2, SUM(field3)
> FROM table1 tb1, table2 tb2
> WHERE tb1.field5 BETWEEN '03/07/2006' AND '03/08/2006'
> AND tb1.field6 = tb2.field7
> AND tb1.field8 = tb2.field8
> AND tb2.field9 BETWEEN 50.00 AND 150.00
> GROUP BY field1
> HAVING SUM(field2) BETWEEN 95.00 AND 100.00
> ORDER BY 2 DESC, field1;
>
> The results I get from Informix and mySql return identical results,
> however postgres includes a great deal more i.e. 11 rows from Informix
> and mySQL, 203 from postgres.
>
> Does anyone have any idea why this disparity may exist?
An obvious source of ambiguity is the date comparison:
tb1.field5 BETWEEN '03/07/2006' AND '03/08/2006'
Is that interval a day or a month (mm/dd/yyyy or dd/mm/yyyy)? Check
your datestyle setting and make sure all systems interpret the date
correctly (or at least the same).
Sincerely,
Niklas Johansson
From | Date | Subject | |
---|---|---|---|
Next Message | TJ O'Donnell | 2006-08-11 00:33:32 | sql error creating function |
Previous Message | Saad Anis | 2006-08-10 22:53:33 | Breaking up a query |