What is the difference between these two queries? Is this a bug?
select case when current_timestamp < '2002-12-06'::date + 1
then 'yes'
else 'no'
end;
--> returns "yes"
select case when current_timestamp < '2002-12-06'::date + 1::interval
then 'yes'
else 'no'
end;
--> returns "no"
Thanks,
--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
There's more to life than just SQL.