projects / evergreen / masslnc.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 16a3653) | patch
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
tree15b4d2bc0d016e4fb83b4ffff72c9c8f27a15183tree
parent16a36534a8b52c849435a4fb3be67d82e9cfe722commit | diff
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 diff | blob | history
Open-ILS/src/sql/Pg/990.schema.unapi.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.function-fixes-for-string-agg.sql [new file with mode: 0644] blob
Evergreen working repo (MassLNC)