summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMatthias Andreas Benkard <code@mail.matthias.benkard.de>2011-03-13 14:43:31 +0100
committerMatthias Andreas Benkard <code@mail.matthias.benkard.de>2011-03-13 14:43:31 +0100
commit56604b9b6d2f1184c67dfdf0592116cb2f6f8a3e (patch)
tree5ecbf0e427cd2004d7b22db22d8f0cae9fce174a
parent5abbade0e992c4b6fc9be545692040fc4450c8e6 (diff)
Database schema: Stylistic changes.
-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