Re: Bug in queries ??

Joost Kraaijeveld wrote:
>
> If I run the following query:
>
> select cast(min(that_time) as abstime), cast(max(that_time) as abstime), (sum(bytes)/(1024*1024)) as "Totaal in
Megabytes"from logs  
> where
> that_time between cast( abstime('2004-10-1 00:00') as int4) and cast( abstime('2004-11-1 00:00') as int4)
> and
> rule_name = 'Incoming 83 50 in' or
> rule_name = 'Outgoing 83 50 out'

Do brackets solve your problem?

WHERE that_time betweeen ...
AND (
   rule_name = ...
   OR rule_name = ...
)

--
   Richard Huxton
   Archonet Ltd