Bob Smith <bsmith@h-e.com> writes:
> '1 day' just means '24 hours'
Yup.
> Is this a Postgres bug, or is this correct SQL behavior?
It's arguably a bug, but it's unfixable without a significant change in
the internal representation and handling of intervals. I don't know
when anyone will get annoyed enough to tackle it. In the meantime,
consider using date +/- integer arithmetic instead of timestamp + interval.
> I'm running Postgres 7.2.2.
You really should be running something newer ...
regards, tom lane