Re: truncating timestamps on arbitrary intervals

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: truncating timestamps on arbitrary intervals
Дата
Msg-id 18539c1b-b672-2328-731c-38ee00fdd966@enterprisedb.com
обсуждение исходный текст
Ответ на Re: truncating timestamps on arbitrary intervals  (John Naylor <john.naylor@enterprisedb.com>)
Ответы Re: truncating timestamps on arbitrary intervals
Список pgsql-hackers
On 30.03.21 18:06, John Naylor wrote:
> Currently, when the origin is after the input, the result is the 
> timestamp at the end of the bin, rather than the beginning as expected. 
> The attached puts the result consistently at the beginning of the bin.

In the patch

+   if (origin > timestamp && stride_usecs > 1)
+       tm_delta -= stride_usecs;

is the condition stride_usecs > 1 really necessary?  My assessment is 
that it's not, in which case it would be better to omit it.



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

Предыдущее
От: "Daniel Westermann (DWE)"
Дата:
Сообщение: Re: check_function_bodies: At least the description seems wrong, since we have prodedures
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Replication slot stats misgivings