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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: Francisco Olarte <folarte(at)peoplecall(dot)com>, Michael Bondarenko <work(dot)michael(dot)2956(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org, dgrowleyml(at)gmail(dot)com
Subject: Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL);
Date: 2024-02-19 17:22:33
Message-ID: 4116086.1708363353@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

jian he <jian(dot)universality(at)gmail(dot)com> writes:
> 9.9.1. EXTRACT, date_part
> hour field description as
> `
> The hour field (0–23)
> `
> Do we need to update for the EXTRACT(INTERVAL) case?

Yeah, probably. I did a bit more wordsmithing too.
Here's a rolled-up patch.

regards, tom lane

Attachment Content-Type Size
v2-interval-extract-docs-fixes.patch text/x-diff 15.9 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander Lakhin 2024-02-20 03:00:00 Re: BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy
Previous Message Amit Langote 2024-02-19 09:45:21 Re: BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2024-02-19 17:37:49 Re: Optimize planner memory consumption for huge arrays
Previous Message Jelte Fennema-Nio 2024-02-19 17:00:11 Re: Avoid switching between system-user and system-username in the doc