Re: Date calculation produces wrong output with 7.02

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: lockhart@fourpalms.org
Cc: mark@summersault.com, pgsql-bugs@postgresql.org, Hackers List <pgsql-hackers@postgresql.org>
Date: 2001-02-23T18:36:19Z
Lists: pgsql-bugs, pgsql-hackers
Thomas Lockhart <lockhart@alumni.caltech.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