Re: [BUGS] Date calculation produces wrong output with 7.02 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [BUGS] Date calculation produces wrong output with 7.02
Date
Msg-id 28978.982953379@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] Date calculation produces wrong output with 7.02  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
List 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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Lock structures
Next
From: Tom Lane
Date:
Subject: Re: CommitDelay performance improvement