projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 836d665) | 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:29:18 +0000 (16:29 -0500)
commitfe8b698f14daf47c6923909be41bb2aa21a54ea2
tree849e273c57fd174d60f6d6bf8825726ce330de7ftree
parent836d66582fd2fdfd8412172ee971392c5519642acommit | 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 ILS