X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=sql%2Fdebbugs_schema.sql;h=4b154786878e4d036fbc8c76360b0f27e5575b33;hb=1fbaca61f2f551b5b2645ce2233a1d964bc93b30;hp=0b5b86e143900dd1146b73c35f0e31474f0feef3;hpb=8656fd028a20c52130f061bc8292c03e3ae514c0;p=debbugs.git

diff --git a/sql/debbugs_schema.sql b/sql/debbugs_schema.sql
index 0b5b86e..4b15478 100644
--- a/sql/debbugs_schema.sql
+++ b/sql/debbugs_schema.sql
@@ -1,4 +1,4 @@
-
+-- -*- mode: sql; sql-product: postgres; -*-
 DROP TABLE bug_status_cache CASCADE;
 DROP VIEW bug_package CASCADE;
 DROP VIEW binary_versions CASCADE;
@@ -574,9 +574,9 @@ CREATE VIEW bug_status --(id,bug_num,tags,subject,
                      WHERE bsp.bug=b.id) AS package
         ) AS package,
 	b.submitter_full AS originator,
-	b.log_modified AS log_modified,
-	b.creation AS date,
-	b.last_modified AS last_modified,
+	EXTRACT(EPOCH FROM b.log_modified) AS log_modified,
+	EXTRACT(EPOCH FROM b.creation) AS date,
+	EXTRACT(EPOCH FROM b.last_modified) AS last_modified,
 	b.done_full AS done,
 	string_agg(bb.blocks::text,' ' ORDER BY bb.blocks) AS blocks,
 	string_agg(bbb.bug::text,' ' ORDER BY bbb.bug) AS blockedby,