Re: Addition and subtraction operations for the interval and integer types

Hi,

Am Mittwoch, dem 25.02.2026 um 23:30 -0700 schrieb David G. Johnston:
> 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.


And there's the orafce extension[1] which adds extensive oracle
datetime compatibility to Postgres (including a more or less compatible
oracle.date type). This is far more useful since it also adds many of
the Oracle functions for datetime operations, too (like sysdate, ...).

[1] https://github.com/orafce/orafce

--
Thanks,
    Bernd