Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL);

On Sat, 17 Feb 2024 at 01:27, Michael Bondarenko
<work(dot)michael(dot)2956(at)gmail(dot)com> wrote:
>
> Adding another inconsistency I found in the docs to this thread (https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT)
>
> The docs say: "source must be a value expression of type timestamp, time, or interval. (Expressions of type date are cast to timestamp and can therefore be used as well.)"
>
> Which implies that the following two results must be the same:
>
> tpch=# select extract(microseconds from date '1924.01.01');
> ERROR: date units "microseconds" not supported
>
> tpch=# select extract(microseconds from (date '1924.01.01')::timestamp);
> extract
> ---------
> 0

It looks like a2da77cdb should have updated the documentation for this.

David