From 56604b9b6d2f1184c67dfdf0592116cb2f6f8a3e Mon Sep 17 00:00:00 2001 From: Matthias Andreas Benkard Date: Sun, 13 Mar 2011 14:43:31 +0100 Subject: Database schema: Stylistic changes. --- schema.sql | 6 +++--- 1 file 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 -- cgit v1.2.3