From 3d1fcf23bcdf2cf473efa34336c11bbab5af5f6b Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 22 Feb 2018 15:19:14 -0500 Subject: [PATCH] LP#1744385: Adjust function for a change in PLPgSQL in PG 9.4.16 Signed-off-by: Mike Rylander Signed-off-by: Kathy Lussier Signed-off-by: Dan Wells --- Open-ILS/src/sql/Pg/300.schema.staged_search.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.highlight_search.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql index 08ca281944..e65df4a744 100644 --- a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql +++ b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql @@ -1432,7 +1432,7 @@ BEGIN tsq_hstore := tsq_map::HSTORE; END IF; - FOR tsq, fields IN SELECT key, value FROM each(tsq_hstore) LOOP + FOR tsq, fields IN SELECT key, value FROM each(tsq_hstore::HSTORE) LOOP SELECT ARRAY_AGG(unnest::INT) INTO afields FROM unnest(regexp_split_to_array(fields,',')); seen := seen || afields; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.highlight_search.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.highlight_search.sql index ed5084272d..e0a91934ee 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.highlight_search.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.highlight_search.sql @@ -447,7 +447,7 @@ BEGIN tsq_hstore := tsq_map::HSTORE; END IF; - FOR tsq, fields IN SELECT key, value FROM each(tsq_hstore) LOOP + FOR tsq, fields IN SELECT key, value FROM each(tsq_hstore::HSTORE) LOOP SELECT ARRAY_AGG(unnest::INT) INTO afields FROM unnest(regexp_split_to_array(fields,',')); seen := seen || afields; -- 2.11.0