Re: BUG #2403: Date arithemtic using INTERVAL in UPDATE command does not work

On Sat, Apr 22, 2006 at 20:34:03 +0000,
  "Harry E. Clarke" <Harry.Clarke@metrosky.co.uk> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      2403
> Logged by:          Harry E. Clarke
> Email address:      Harry.Clarke@metrosky.co.uk
> PostgreSQL version: 8.1.3
> Operating system:   Suse Linux 10.0
> Description:        Date arithemtic using INTERVAL in UPDATE command does
> not work
> Details:
>
> Entering the command
>
> UPDATE table SET col_date = col_date - INTERVAL '100' YEAR where condition;
>
> does not perform any date aritimetic, and thus the date value in col_date
> remains unchanged. col_date contains a value such as '2039-12-07'. If the
> command
>
> UPDATE table SET col_date = DATE '1939-12-07' where condition;
>
> is entered, the command executes as expected.

You probably just made a mistake with the condition. But since you haven't
shown us what it was, we can't give you any specific advice about it.