LP#1441750: use string_agg (again)
authorBen Shum <ben@evergreener.net>
Wed, 2 May 2018 22:31:08 +0000 (17:31 -0500)
committerJason Boyer <JBoyer@equinoxOLI.org>
Sun, 5 Mar 2023 21:31:52 +0000 (16:31 -0500)
commit1c35ee36029aa85e6a04168fc544d5a287638a9a
tree15b4d2bc0d016e4fb83b4ffff72c9c8f27a15183
parent16a36534a8b52c849435a4fb3be67d82e9cfe722
LP#1441750: use string_agg (again)

Some older style ARRAY_TO_STRING(ARRAY_AGG()) should be replaced to
use the native STRING_AGG() that comes with PG 9+.  This should improve
performance for these functions.

Signed-off-by: Ben Shum <ben@evergreener.net>
Signed-off-by: Jason Stephenson <jason@sigio.com>
Signed-off-by: Jason Boyer <JBoyer@equinoxOLI.org>
Open-ILS/src/sql/Pg/300.schema.staged_search.sql
Open-ILS/src/sql/Pg/990.schema.unapi.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.function-fixes-for-string-agg.sql [new file with mode: 0644]