Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

create table your_table (
  seconds int not null
  )

CREATE TABLE


insert into your_table
values   (34837), (51714), (0),(86400);

INSERT 0 4


select
    seconds
  , seconds / 3600 hh
  , (seconds / 60) % 60 mm
  , seconds % 60 ss
  , concat(right('00' || seconds / 3600,2),':'
         , right('00' || (seconds / 60) % 60,2),':'
         , right('00' || seconds % 60,2)
         ) hh_mm_ss
from your_table


seconds
hh
mm
ss
hh_mm_ss


34837
9
40
37
09:40:37

51714
14
21
54
14:21:54

0
0
0
0
00:00:00

86400
24
0
0
24:00:00



SELECT 4

seconds	hh	mm	ss	hh_mm_ss
34837	9	40	37	09:40:37
51714	14	21	54	14:21:54
0	0	0	0	00:00:00
86400	24	0	0	24:00:00