From ae293171deabeff334959653f9868b95cf866fb6 Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 26 Jun 2008 12:47:09 +0000 Subject: [PATCH] array_accum defined in the new aggregate function file git-svn-id: svn://svn.open-ils.org/ILS/trunk@9934 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/020.schema.functions.sql | 8 +------- 1 file changed, 1 insertion(+), 7 deletions(-) diff --git a/Open-ILS/src/sql/Pg/020.schema.functions.sql b/Open-ILS/src/sql/Pg/020.schema.functions.sql index 9ea4e8d092..efc253d7b6 100644 --- a/Open-ILS/src/sql/Pg/020.schema.functions.sql +++ b/Open-ILS/src/sql/Pg/020.schema.functions.sql @@ -112,7 +112,7 @@ $$ LANGUAGE PLPERLU; CREATE OR REPLACE FUNCTION public.call_number_dewey( TEXT ) RETURNS TEXT AS $$ my $txt = shift; $txt =~ s/^\s+//o; - $txt =~ s/[\[\]\{\}\(\)`'"#<>\*\?\-\+\$\\]+//o; + $txt =~ s/[\[\]\{\}\(\)`'"#<>\*\?\-\+\$\\]+//og; $txt =~ s/\s+$//o; if ($txt =~ /(\d{3}(?:\.\d+)?)/o) { return $1; @@ -206,10 +206,4 @@ CREATE OR REPLACE FUNCTION actor.org_unit_proximity ( INT, INT ) RETURNS INT AS ) z; $$ LANGUAGE SQL STABLE; -CREATE AGGREGATE array_accum ( - sfunc = array_append, - basetype = anyelement, - stype = anyarray, - initcond = '{}' -); -- 2.43.2