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
