Re: Date calculation produces wrong output with 7.02

Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> writes:
> This problem is in the current CVS tree also. A workaround of removing
> the reltime==int assumed compatibility could be applied to 7.1 (I
> haven't thought of what that would affect) or we can build some explicit
> operators to make sure that the seconds->days conversion happens (which
> would require an initdb).
> btw, "interval" is to be preferred over "reltime" for most operations,
> as recommended in the PostgreSQL docs on data types.

Removing the binary compatibility was my thought also. If we are trying
to discourage use of reltime, then this seems like a good change to
make...

regards, tom lane