mvhub-dev team mailing list archive

[noreply@xxxxxxxxxxxxx]

------------------------------------------------------------
revno: 417
tags: 2010-06-18
committer: Dan MacNeil <dan@xxxxxxxxxx>
branch nick: trunk
timestamp: Fri 2010-06-18 15:40:06 -0400
message:
  fixed syntax error in database mismatch kludgery 
modified:
  app-mvhub/setup/database/sql/005_synonym_cat_functions.sql


--
lp:mvhub
https://code.launchpad.net/~mvhub-commit/mvhub/trunk

Your team MVHub Developers is subscribed to branch lp:mvhub.
To unsubscribe from this branch go to https://code.launchpad.net/~mvhub-commit/mvhub/trunk/+edit-subscription

=== modified file 'app-mvhub/setup/database/sql/005_synonym_cat_functions.sql'
--- app-mvhub/setup/database/sql/005_synonym_cat_functions.sql	2010-06-18 19:18:28 +0000
+++ app-mvhub/setup/database/sql/005_synonym_cat_functions.sql	2010-06-18 19:40:06 +0000
@@ -1,7 +1,7 @@
 BEGIN;
 INSERT INTO version_log (version, note ) 
-	VALUES (5,'adding two functions to return concatenated 
-synonyms');
+	VALUES (5,'adding two functions to return concatenated synonyms');
+
 /* Returns the concatenation of its 2 arguments, separated by a comma and a space. */
 CREATE OR REPLACE FUNCTION  our_concat(text, text) RETURNS text AS 
 $$
@@ -14,7 +14,7 @@
 /* Returns a concatenation of all of the values in a grouped column, 
    delimited by a comma and a space. 
 */
-DROP AGGREGATE IF EXISTS our_aggregate_concat;
+DROP AGGREGATE IF EXISTS our_aggregate_concat(text);
 
 CREATE AGGREGATE our_aggregate_concat (
     sfunc = our_concat,