summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--schema.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/schema.sql b/schema.sql
index 52a6ff2..39ddb53 100644
--- a/schema.sql
+++ b/schema.sql
@@ -238,7 +238,7 @@ $$ LANGUAGE plpgsql;
-- SELECT article_revisions_for_characteristics(70, ARRAY[ROW(ARRAY[ROW('language', 'de')::characteristic])]::characteristic_list[]);
-CREATE OR REPLACE FUNCTION older_revision(
+CREATE FUNCTION older_revision(
IN article_revisions,
IN article_revisions,
OUT article_revisions
@@ -256,7 +256,7 @@ CREATE AGGREGATE oldest_revision (article_revisions) (
);
-CREATE OR REPLACE FUNCTION more_recent_revision(
+CREATE FUNCTION more_recent_revision(
IN article_revisions,
IN article_revisions,
OUT article_revisions
@@ -279,7 +279,7 @@ CREATE VIEW article_comment_counts AS
SELECT a.id AS article,
count(c.*) AS comment_count
FROM articles a
- LEFT JOIN comments c
+ LEFT OUTER JOIN comments c
ON c.article = a.id
AND EXISTS (SELECT *
FROM comment_revisions