Re: [BUGS] Date calculation produces wrong output with 7.02

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] Date calculation produces wrong output with 7.02
Дата
Msg-id 28978.982953379@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [BUGS] Date calculation produces wrong output with 7.02  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Lock structures
Следующее
От: Tom Lane
Дата:
Сообщение: Re: CommitDelay performance improvement