X-Git-Url: http://git.squeep.com/?p=websub-hub;a=blobdiff_plain;f=src%2Fdb%2Fpostgres%2Fsql%2Ftopic-get-info-all.sql;h=4d9aa0de069ee86185c5fd23479e4285effc6b47;hp=e4289037e1097a0a0ef2394ce22c61f163e291bd;hb=e5c67776b7a31daac84b5a047f9e566657e5b7f9;hpb=acf63f7913320f8edb9db9dc31d13ec7ff5d104f

diff --git a/src/db/postgres/sql/topic-get-info-all.sql b/src/db/postgres/sql/topic-get-info-all.sql
index e428903..4d9aa0d 100644
--- a/src/db/postgres/sql/topic-get-info-all.sql
+++ b/src/db/postgres/sql/topic-get-info-all.sql
@@ -3,9 +3,9 @@ SELECT
 	t.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,
 	t.publisher_validation_url,
 	t.content_hash_algorithm,
 	t.is_active,