fix postgres duration queries to return expected integer type

[websub-hub] / src / db / postgres / sql / topic-get-by-id.sql

diff --git a/src/db/postgres/sql/topic-get-by-id.sql b/src/db/postgres/sql/topic-get-by-id.sql
index aa18336c2246a79481b43a1f9493d6ec9fa85350..71d36ed1ac8e93eb6616a1597029947e42665542 100644 (file)
--- a/src/db/postgres/sql/topic-get-by-id.sql
+++ b/src/db/postgres/sql/topic-get-by-id.sql
@@ -3,9 +3,9 @@ SELECT
        id,
        created,
        url,
-       extract(epoch FROM lease_seconds_preferred) AS lease_seconds_preferred,
-       extract(epoch FROM lease_seconds_min) AS lease_seconds_min,
-       extract(epoch FROM lease_seconds_max) AS lease_seconds_max,
+       extract(epoch FROM lease_seconds_preferred)::integer AS lease_seconds_preferred,
+       extract(epoch FROM lease_seconds_min)::integer AS lease_seconds_min,
+       extract(epoch FROM lease_seconds_max)::integer AS lease_seconds_max,
        publisher_validation_url,
        content_hash_algorithm,
        is_active,
@@ -15,6 +15,8 @@ SELECT
        content_fetch_attempts_since_success,
        content_updated,
        content_hash,
-       content_type
+       content_type,
+       http_etag,
+       http_last_modified
 FROM topic
 WHERE id = $(topicId)