pgsql: interval: round values when spilling to months

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: interval: round values when spilling to months
Date: 2021-08-03 16:10:59
Message-ID: E1mAx0N-0004uL-3T@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

interval: round values when spilling to months

Previously spilled units greater than months were truncated to months.
Also document the spill behavior.

Reported-by: Bryn Llewelly

Discussion: https://postgr.es/m/BDAE4B56-3337-45A2-AC8A-30593849D6C0@yugabyte.com

Backpatch-through: master

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/95ab1e0a9db321dd796344d526457016eada027f

Modified Files
--------------
doc/src/sgml/datatype.sgml | 25 ++++++++++++++-----------
src/backend/utils/adt/datetime.c | 16 ++++++----------
src/interfaces/ecpg/pgtypeslib/interval.c | 16 ++++++----------
3 files changed, 26 insertions(+), 31 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2021-08-03 16:18:33 pgsql: doc: interval spill method for units greater than months
Previous Message Bruce Momjian 2021-08-03 15:58:50 pgsql: pg_upgrade: warn about extensions that need updating