On Thu, Apr 27, 2006 at 16:55:22 +1000,
Chris Velevitch <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
