From e6eb17aa52e6dab2bbbb12674a717fcdf01023d4 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Thu, 16 Jan 2014 20:59:13 -0500 Subject: [PATCH] Keep dropping and creating array_accum() We want to keep array_accum() around for now to support any custom SQL that sites might have generated. Plus, we don't want it to show up in our search path ahead of the native array_agg()! We can always rebase this as a fix into the previous commit to squash history a bit. "Nope, that never happened!" Signed-off-by: Dan Scott Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/002.functions.aggregate.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/002.functions.aggregate.sql b/Open-ILS/src/sql/Pg/002.functions.aggregate.sql index 57f0ce570f..cb42cd7b06 100644 --- a/Open-ILS/src/sql/Pg/002.functions.aggregate.sql +++ b/Open-ILS/src/sql/Pg/002.functions.aggregate.sql @@ -17,12 +17,12 @@ BEGIN; -DROP AGGREGATE IF EXISTS array_agg(anyelement) CASCADE; +DROP AGGREGATE IF EXISTS array_accum(anyelement) CASCADE; DROP AGGREGATE IF EXISTS public.first(anyelement) CASCADE; DROP AGGREGATE IF EXISTS public.last(anyelement) CASCADE; DROP AGGREGATE IF EXISTS public.agg_text(text) CASCADE; -CREATE AGGREGATE array_agg ( +CREATE AGGREGATE array_accum ( sfunc = array_append, basetype = anyelement, stype = anyarray, -- 2.43.2