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

On Sat, 17 Feb 2024 at 01:27, Michael Bondarenko
 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