On Sat, Apr 22, 2006 at 20:34:03 +0000,
"Harry E. Clarke" <Harry(dot)Clarke(at)metrosky(dot)co(dot)uk> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2403
> Logged by: Harry E. Clarke
> Email address: Harry(dot)Clarke(at)metrosky(dot)co(dot)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.