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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Gregory Smith <gregsmithpgsql(at)gmail(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: proposal: rounding up time value less than its unit.
Date: 2014-09-25 05:04:45
Message-ID: 7378.1411621485@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> On Thu, Sep 25, 2014 at 12:46 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> TBH I've also been wondering whether any of these proposed cures are
>> better than the disease. The changes that can be argued to make the
>> behavior more sane are also ones that introduce backwards compatibility
>> issues of one magnitude or another. And I do not have a lot of sympathy
>> for "let's not change anything except to throw an error in a case that
>> seems ambiguous". That's mostly being pedantic, not helpful, especially
>> seeing that the number of field complaints about it is indistinguishable
>> from zero.

> Then what does it matter that we'd choose to error-out?

The number of complaints about the *existing* behavior is indistinguishable
from zero (AFAIR anyway). It does not follow that deciding to throw an
error where we did not before will draw no complaints.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Smith 2014-09-25 05:27:35 Re: add modulo (%) operator to pgbench
Previous Message David Johnston 2014-09-25 04:55:46 Re: proposal: rounding up time value less than its unit.