merge stable
authorAlexandre Fayolle <alexandre.fayolle@logilab.fr>
Wed, 16 Dec 2009 11:17:51 +0100
branchstable
changeset 4127 3b442047db3f
parent 4126 2eb47c1efee1 (diff)
parent 4125 a32b0dc8575c (current diff)
child 4128 8aaa5c6b9d1f
merge
--- a/schemas/_regproc.postgres.sql	Wed Dec 16 09:11:41 2009 +0100
+++ b/schemas/_regproc.postgres.sql	Wed Dec 16 11:17:51 2009 +0100
@@ -5,10 +5,12 @@
 
 */
 
+DROP FUNCTION IF EXISTS comma_join (anyarray) CASCADE;
 CREATE FUNCTION comma_join (anyarray) RETURNS text AS $$
     SELECT array_to_string($1, ', ')
 $$ LANGUAGE SQL;;
 
+DROP AGGREGATE IF EXISTS group_concat (anyelement) CASCADE;
 CREATE AGGREGATE group_concat (
   basetype = anyelement,
   sfunc = array_append,
@@ -19,6 +21,7 @@
 
 
 
+DROP FUNCTION IF EXISTS limit_size (fulltext text, format text, maxsize integer);
 CREATE FUNCTION limit_size (fulltext text, format text, maxsize integer) RETURNS text AS $$
 DECLARE
     plaintext text;
@@ -39,7 +42,7 @@
 END
 $$ LANGUAGE plpgsql;;
 
-
+DROP FUNCTION IF EXISTS text_limit_size (fulltext text, maxsize integer);
 CREATE FUNCTION text_limit_size (fulltext text, maxsize integer) RETURNS text AS $$
 BEGIN
     RETURN limit_size(fulltext, 'text/plain', maxsize);