Re: proposal: rounding up time value less than its unit.

From: David Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Greg Stark <stark(at)mit(dot)edu>
Cc: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Tomonari Katsumata <t(dot)katsumata1122(at)gmail(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>
Subject: Re: proposal: rounding up time value less than its unit.
Date: 2014-09-23 20:48:32
Message-ID: CAKFQuwZB3vGZj=QgmHUC24KKGFkvPUkOq2o_AZ8yNBdi-zjeZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Sep 23, 2014 at 3:05 PM, Greg Stark <stark(at)mit(dot)edu> wrote:

> Fwiw I agree with TL2. The simplest, least surprising behaviour to explain
> to users is to say we round to nearest and if that means we rounded to zero
> (or another special value) we throw an error. We could list the minimum
> value in pg_settings and maybe in documentation.
>
​I'm not sure TL2 would agree that you are agreeing with him...

To the other point the minimum unit-less value is 1. The unit that is
applied is already listed in pg_settings​ and the documentation. While 0
is allowed it is more of a flag than a value.

David J.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2014-09-23 20:53:44 Re: Scaling shared buffer eviction
Previous Message Stephen Frost 2014-09-23 20:33:15 Re: RLS feature has been committed