Re: [SQL] Interval subtracting

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [SQL] Interval subtracting
Дата
Msg-id 16845.1141255065@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [SQL] Interval subtracting  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> Well, the question is whether justify_days has a sane definition that is
>> different from this.  Based on your example, I'm not seeing one.

> Uh, justify days only deals with days <--> months conversions.  There is
> no processing for hours.  I don't understand your comment.

So it won't guarantee that hours has a consistent sign.  If you're OK
with that, then that's fine, let's make justify_days work that way and
then provide a justify_interval that processes all three fields.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [SQL] Interval subtracting
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] Interval subtracting