Request a Demo
Home   >   mailing lists

Re: Addition and subtraction operations for the interval and integer types - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Addition and subtraction operations for the interval and integer types
Date
Msg-id CAKFQuwaQu8zmij-ca8C-vqEBZB7imeHAZ1ArSxj4N1dZ8AHgVg@mail.gmail.com
Whole thread Raw
In response to Addition and subtraction operations for the interval and integer types  ("yangyz" <1197620467@qq.com>)
Responses Re: Addition and subtraction operations for the interval and integer types
List pgsql-hackers
Tree view
On Wednesday, February 25, 2026, yangyz <1197620467@qq.com> wrote:
 In order to enhance the compatibility 
between Oracle and PostgreSQL, I implemented it.

This isn’t all that appealing to me.  There isn’t really a goal of increased compatibility’s aside from with the SQL Standard (extensions can accept that burden IMO).  And the utility of preventing people from having to explicitly write the word ‘day’ is marginal.  And given the already numerous ways to combine data types in date/time I hesitate to add yet more.

David J.

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication
Next
From: Chao Li
Date:
Subject: Re: Patch: Add tsmatch JSONPath operator for granular Full Text Search