Re: Interval overflow?

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Interval overflow?
Дата
Msg-id 1183154039.28247.49.camel@dogma.v10.wvs
обсуждение исходный текст
Ответ на Re: Interval overflow?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Fri, 2007-06-29 at 17:31 -0400, Tom Lane wrote:
> It looks like his case is overflowing the int8 microseconds field of
> the interval.  On my machine, the seconds field is double so it does not
> overflow, but interval_out tries to convert the computed hours value
> to int32, and *that* overflows.
>
> The best we can do for Jeff is throw an error in interval addition.

That sounds reasonable to me.

> In the float case it could be wished that we could print any result
> we can store ...
>

Agreed.

Regards,
    Jeff Davis




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

Предыдущее
От: "Gurjeet Singh"
Дата:
Сообщение: Re: a JOIN on same table, but 'slided over'
Следующее
От: Oisin Glynn
Дата:
Сообщение: Re: [pgsql] Simple backup utility like mysqldump?