how do i get around this?
select sum(total) from lineitemsnext where date <= ('now'::date + '1
month'::timespan);
ERROR: Unable to identify an operator '<=' for types 'date' and
'datetime'
You will have to retype this query using an explicit cast
-----------------------------------------------------------------------------
david@backpack.com BackPack Software, Inc. www.backpack.com
+1 651.645.7550 voice "Life is an Adventure.
+1 651.645.9798 fax Don't forget your BackPack!"
-----------------------------------------------------------------------------