From 5ab96057d2b29160fc2a52d370d7265813ebefde Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Sun, 16 Oct 2011 10:26:00 -0400 Subject: [PATCH] ARRAY_ACCUM() -> ARRAY_AGG() for new authority nfi functions Fix the new places where array_accum() has been able to sneak into the schema. Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/011.schema.authority.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/Open-ILS/src/sql/Pg/011.schema.authority.sql b/Open-ILS/src/sql/Pg/011.schema.authority.sql index 4f8fc74e0d..bc2967ea32 100644 --- a/Open-ILS/src/sql/Pg/011.schema.authority.sql +++ b/Open-ILS/src/sql/Pg/011.schema.authority.sql @@ -605,13 +605,13 @@ END; $$ LANGUAGE PLPGSQL ROWS 10; CREATE OR REPLACE FUNCTION authority.axis_authority_tags(a TEXT) RETURNS INT[] AS $$ - SELECT ARRAY_ACCUM(field) FROM authority.browse_axis_authority_field_map WHERE axis = $1; + SELECT ARRAY_AGG(field) FROM authority.browse_axis_authority_field_map WHERE axis = $1; $$ LANGUAGE SQL; CREATE OR REPLACE FUNCTION authority.axis_authority_tags_refs(a TEXT) RETURNS INT[] AS $$ SELECT ARRAY_CAT( ARRAY[a.field], - (SELECT ARRAY_ACCUM(x.id) FROM authority.control_set_authority_field x WHERE x.main_entry = a.field) + (SELECT ARRAY_AGG(x.id) FROM authority.control_set_authority_field x WHERE x.main_entry = a.field) ) FROM authority.browse_axis_authority_field_map a WHERE axis = $1 @@ -620,13 +620,13 @@ $$ LANGUAGE SQL; CREATE OR REPLACE FUNCTION authority.btag_authority_tags(btag TEXT) RETURNS INT[] AS $$ - SELECT ARRAY_ACCUM(authority_field) FROM authority.control_set_bib_field WHERE tag = $1 + SELECT ARRAY_AGG(authority_field) FROM authority.control_set_bib_field WHERE tag = $1 $$ LANGUAGE SQL; CREATE OR REPLACE FUNCTION authority.btag_authority_tags_refs(btag TEXT) RETURNS INT[] AS $$ SELECT ARRAY_CAT( ARRAY[a.authority_field], - (SELECT ARRAY_ACCUM(x.id) FROM authority.control_set_authority_field x WHERE x.main_entry = a.authority_field) + (SELECT ARRAY_AGG(x.id) FROM authority.control_set_authority_field x WHERE x.main_entry = a.authority_field) ) FROM authority.control_set_bib_field a WHERE a.tag = $1 @@ -635,13 +635,13 @@ $$ LANGUAGE SQL; CREATE OR REPLACE FUNCTION authority.atag_authority_tags(atag TEXT) RETURNS INT[] AS $$ - SELECT ARRAY_ACCUM(id) FROM authority.control_set_authority_field WHERE tag = $1 + SELECT ARRAY_AGG(id) FROM authority.control_set_authority_field WHERE tag = $1 $$ LANGUAGE SQL; CREATE OR REPLACE FUNCTION authority.atag_authority_tags_refs(atag TEXT) RETURNS INT[] AS $$ SELECT ARRAY_CAT( ARRAY[a.id], - (SELECT ARRAY_ACCUM(x.id) FROM authority.control_set_authority_field x WHERE x.main_entry = a.id) + (SELECT ARRAY_AGG(x.id) FROM authority.control_set_authority_field x WHERE x.main_entry = a.id) ) FROM authority.control_set_authority_field a WHERE a.tag = $1 -- 2.11.0