| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | eugeny(at)zhuzhnev(dot)com |
| Subject: | BUG #17866: behavior does not match documentation |
| Date: | 2023-03-23 15:10:08 |
| Message-ID: | 17866-18eb70095b1594e2@postgresql.org |
| Views: | Whole Thread |Raw Message |Download mbox |Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 17866
Logged by: Евгений Жужнев
Email address: eugeny(at)zhuzhnev(dot)com
PostgreSQL version: 15.2
Operating system: Oracle Linux 9
Description:
sudo -u postgres psql pgc
psql (15.2)
Type "help" for help.
pgc=# SELECT EXTRACT(EPOCH FROM INTERVAL '5 days 3 hours');
extract
---------------
442800.000000
(1 row)
--
But in documentation we can see:
SELECT EXTRACT(EPOCH FROM INTERVAL '5 days 3 hours');
Result: 442800
https://www.postgresql.org/docs/current/functions-datetime.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-03-23 15:30:11 | Re: BUG #17864: pg_notify is publishing message twice |
| Previous Message | Devrim Gündüz | 2023-03-23 15:03:24 | Re: BUG #17861: Disappearance of packages in repo for rhel-8 |