2006/11/9, Andrus <eetasoft@xxxxxxxxx>:
Maybe:
('2006-10-16'::DATE BETWEEN '2006-10-30'::date AND '9999-12-31'::date) OR
('2006-10-31'::DATE BETWEEN '2006-10-30'::date AND '9999-12-31'::date)
> They're adjacent, they don't overlap. Check the documentation on OVERLAPS,
> I'm sure it's explicit about whether it is inclusive or exclusive (the
> latter apparently).
8.2 doc does not explain term overlap. It only says:
"This _expression_ yields true when two time periods (defined by their
endpoints) overlap"
>> How to make overlaps to return correct result?
>
> select 1 where ('2006-10-30'::date, '9999-12-31'::date) OVERLAPS
> ('2006-10-16'::DATE, '2006-10-31':: DATE);
In real queries I have column names and parameters instead of data
constants.
The only way it seems to replace OVERLAPS operator with AND, OR, <=
operators.
Is it so ?
Andrus.
Maybe:
('2006-10-16'::DATE BETWEEN '2006-10-30'::date AND '9999-12-31'::date) OR
('2006-10-31'::DATE BETWEEN '2006-10-30'::date AND '9999-12-31'::date)
--
William Leite Araújo
