Re: how to cast for dates/datetimes?

> I suspect that your calculation yeilds a timestamp instead of date because
> 'now' is a timestamp, not a date, try:
>
> select sum(total) from lineitemsnext where date <= ('now'::date + '1
> month'::timespan)::date;

This one did the trick.  I'll try the other variants later on.

Thanks!

-duck


-----------------------------------------------------------------------------
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!"
-----------------------------------------------------------------------------