Postgres Pro
Downloads
Home   >   mailing lists

Re: proposal: rounding up time value less than its unit. - Mailing list pgsql-hackers

From Greg Stark
Subject Re: proposal: rounding up time value less than its unit.
Date
Msg-id CAM-w4HOEM6=M8RtMM5LDaoLhwbF8Y9b1n1NioU-zRN5tbd9T1Q@mail.gmail.com
Whole thread Raw
In response to Re: proposal: rounding up time value less than its unit.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: proposal: rounding up time value less than its unit.
Re: proposal: rounding up time value less than its unit.
List pgsql-hackers
Tree view 
On Sat, Aug 23, 2014 at 9:38 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Ah.  Okay, but then what's wrong with the original proposal of "use ceil()
> instead of floor()"?  Basically I think the idea of treating fractions
> less than one differently from fractions greater than one is bogus; nobody
> will ever find that intuitive.

Or make it an error to specify a value that rounds to 0 but isn't 0.



-- 
greg

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: change alter user to be a true alias for alter role
Next
From: David G Johnston
Date:
Subject: Re: proposal: rounding up time value less than its unit.