From 1a042ec22d9150ca6a05a87ddeb371b9802d7262 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Thu, 13 Oct 2011 10:45:25 -0400 Subject: [PATCH] One more STRING_AGG() conversion Teach biblio.indexing_ingest_or_delete() to use STRING_AGG() where appropriate. Signed-off-by: Dan Scott Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index 10fc2de619..a163d0d833 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -1304,7 +1304,7 @@ BEGIN FOR attr_def IN SELECT * FROM config.record_attr_definition ORDER BY format LOOP IF attr_def.tag IS NOT NULL THEN -- tag (and optional subfield list) selection - SELECT ARRAY_TO_STRING(ARRAY_AGG(value), COALESCE(attr_def.joiner,' ')) INTO attr_value + SELECT STRING_AGG(value, COALESCE(attr_def.joiner,' ')) INTO attr_value FROM (SELECT * FROM metabib.full_rec ORDER BY tag, subfield) AS x WHERE record = NEW.id AND tag LIKE attr_def.tag -- 2.43.2