fix postgres duration queries to return expected integer type
[websub-hub] / src / db / postgres / sql / topic-get-content-by-id.sql
1 -- topic including content
2 SELECT *,
3 extract(epoch FROM lease_seconds_preferred)::integer AS lease_seconds_preferred,
4 extract(epoch FROM lease_seconds_min)::integer AS lease_seconds_min,
5 extract(epoch FROM lease_seconds_max)::integer AS lease_seconds_max
6 FROM topic
7 WHERE id = $(topicId)