Re: [BUGS] BUG #14632: Plus and minus operators inconsistency with leap years and year intervals.

От

Pietro Pugni

Тема

Дата

27 апреля 2017 г. в 02:16:13

Msg-id

62AA1945-7282-4166-8991-E6EA4C9C37A5@gmail.com

обсуждение

Ответ на

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals. (David G. Johnston)

Список

pgsql-bugs

Дерево обсуждения

[BUGS] BUG #14632: Plus and minus operators inconsistency with leap yearsand year intervals. pietro.pugni@gmail.com 26 апреля 2017 г. в 21:23:22

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals. "David G. Johnston" <david.g.johnston@gmail.com> 26 апреля 2017 г. в 21:29:18

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency with leap years and year intervals. Pietro Pugni <pietro.pugni@gmail.com> 26 апреля 2017 г. в 23:30:50

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals. John R Pierce <pierce@hogranch.com> 26 апреля 2017 г. в 23:53:10

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals. "David G. Johnston" <david.g.johnston@gmail.com> 26 апреля 2017 г. в 23:56:20

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals. John R Pierce <pierce@hogranch.com> 27 апреля 2017 г. в 00:07:03

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency with leap years and year intervals. Tom Lane <tgl@sss.pgh.pa.us> 27 апреля 2017 г. в 00:25:18

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency with leap years and year intervals. Pietro Pugni <pietro.pugni@gmail.com> 27 апреля 2017 г. в 01:44:40

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency with leap years and year intervals. Andrew Gierth <andrew@tao11.riddles.org.uk> 27 апреля 2017 г. в 13:00:26

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals. "David G. Johnston" <david.g.johnston@gmail.com> 27 апреля 2017 г. в 02:05:27

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency with leap years and year intervals. Pietro Pugni <pietro.pugni@gmail.com> 27 апреля 2017 г. в 02:16:13

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals. "David G. Johnston" <david.g.johnston@gmail.com> 27 апреля 2017 г. в 00:15:45

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency with leap years and year intervals. Pietro Pugni <pietro.pugni@gmail.com> 27 апреля 2017 г. в 02:01:22

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals. "David G. Johnston" <david.g.johnston@gmail.com> 27 апреля 2017 г. в 02:18:52

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals. "David G. Johnston" <david.g.johnston@gmail.com> 27 апреля 2017 г. в 02:25:53

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals. Marko Tiikkaja <marko@joh.to> 27 апреля 2017 г. в 02:08:32

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency with leap years and year intervals. Pietro Pugni <pietro.pugni@gmail.com> 27 апреля 2017 г. в 02:48:41

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals. Pantelis Theodosiou <ypercube@gmail.com> 27 апреля 2017 г. в 15:31:16

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency with leap years and year intervals. Pietro Pugni <pietro.pugni@gmail.com> 28 апреля 2017 г. в 12:04:01

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency with leap years and year intervals. Pietro Pugni <pietro.pugni@gmail.com> 28 апреля 2017 г. в 13:46:38

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals. Marko Tiikkaja <marko@joh.to> 27 апреля 2017 г. в 00:06:50

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals. "David G. Johnston" <david.g.johnston@gmail.com> 27 апреля 2017 г. в 00:25:57

Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals. Marko Tiikkaja <marko@joh.to> 27 апреля 2017 г. в 00:08:24

On Wed, Apr 26, 2017 at 3:44 PM, Pietro Pugni <pietro.pugni@gmail.com> wrote:
I don't know if you intended to supersize your response but it ended up that way in my mail client.

It was my client (Mail on OS X) that messed up font size and just saw it from the web browser..

I'll agree that the age function has enough data available to it to return 10 years in this case.

28 days, target month is February in a non-leap-year (1922), convert to 1 month. 11 months + 1 month = 12 months = 1 year. 9 years + 1 year = 10 years.

But the provided answer is correct as well...

This is the sort of ambiguity/inconsistency I was referring to. Intervals need a context in order to have a meaning but they never gave me issues except from leap years. So, I think it should be solved by “simply” threating leap years in a different way. Intervals are used to approach a human meaning of time measure, what we call “age”. Leap years should represent a specific exception IMHO.

Kind regards,

Pietro Pugni

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

Предыдущее

От: Michael Paquier

Дата: 27 апреля 2017 г. в 02:12:30

Сообщение: Re: [BUGS] Concurrent ALTER SEQUENCE RESTART Regression

Следующее

От: David G. Johnston

Дата: 27 апреля 2017 г. в 02:18:52

Сообщение: Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals.