From a0aa2ec198a218202fdcb3d4f13b4ecc028e4037 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 23 May 2019 15:12:43 +0000 Subject: [PATCH] JBAS-2285 authority browse sql rearrangments Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql | 19 +++++++++---------- 1 file changed, 9 insertions(+), 10 deletions(-) diff --git a/KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql b/KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql index f375bed20d..0fb7d0ffa1 100644 --- a/KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql +++ b/KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql @@ -6854,16 +6854,6 @@ END; $f$ LANGUAGE PLPGSQL STABLE ROWS 1; CREATE OR REPLACE FUNCTION - metabib.browse_authority_is_unauthorized (mbe_id BIGINT, field_class TEXT) - RETURNS TABLE (auth_tag CHARACTER(3), atag INTEGER, record BIGINT) AS -$$ - SELECT metabib.browse_authority_is_unauthorized( - mbe_id, (SELECT ARRAY_AGG(id) - FROM config.metabib_field WHERE field_class = $2) - ); -$$ LANGUAGE SQL; - -CREATE OR REPLACE FUNCTION metabib.browse_authority_is_unauthorized (mbe_id BIGINT, fields INTEGER[]) RETURNS TABLE (auth_tag CHARACTER(3), atag INTEGER, record BIGINT) AS $$ @@ -6883,6 +6873,15 @@ $$ LIMIT 1 $$ LANGUAGE SQL; +CREATE OR REPLACE FUNCTION + metabib.browse_authority_is_unauthorized (mbe_id BIGINT, field_class TEXT) + RETURNS TABLE (auth_tag CHARACTER(3), atag INTEGER, record BIGINT) AS +$$ + SELECT metabib.browse_authority_is_unauthorized( + mbe_id, (SELECT ARRAY_AGG(id) + FROM config.metabib_field WHERE field_class = $2) + ); +$$ LANGUAGE SQL; --INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.0.4', :eg_version); --SELECT evergreen.upgrade_deps_block_check('1088', :eg_version); -- 2.11.0