On Thu, Apr 27, 2006 at 16:55:22 +1000, Chris Velevitch <chris.velevitch@xxxxxxxxx> wrote: > Seems like the problem has something to do with date arithmetic. I > can't seem to add an integer expression to a date constant. It works > if I add a integer constant to a date constant, but that's not what I > want. I tried cast(expression as integer) + date '2006-04-09' but I > get 'ERROR: operator does not exist: integer + date'. What do I need > to do to add a number to a date? I believe that has been fixed in recent version of postgres. At some point in the past there was only a date + int operator and not an int + date operator. Overloading makes it easy to forget that those are two different operators.