> regression=# explain SELECT * FROM sm_item WHERE
> regression-# item_created_date_start BETWEEN '1685-01-01' AND
'1685-12-31';
> QUERY PLAN
Hmm, if date includes the time, shouldn't the query be:
SELECT *
FROM sm_item
WHERE item_created_date_start >= '1685-01-01'
AND item_created_date_start < '1686-01-01'
Vincent Hikida,
Member of Technical Staff - Urbana Software, Inc.
"A Personalized Learning Experience"
www.UrbanaSoft.com