X-Git-Url: http://git.squeep.com/?p=websub-hub;a=blobdiff_plain;f=src%2Fdb%2Fpostgres%2Fsql%2Ftopic-get-by-url.sql;h=877c2a1720da377e09d5058491af65df95e0b992;hp=adc9ffbc47722e01ce054b9ec547ba6fb14818bc;hb=e5c67776b7a31daac84b5a047f9e566657e5b7f9;hpb=9696c012e6b9a6c58904baa397ca0ebf78112316

diff --git a/src/db/postgres/sql/topic-get-by-url.sql b/src/db/postgres/sql/topic-get-by-url.sql
index adc9ffb..877c2a1 100644
--- a/src/db/postgres/sql/topic-get-by-url.sql
+++ b/src/db/postgres/sql/topic-get-by-url.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 url = $(topicUrl)