projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 4ab4869) | patch
LP#1441750: use string_agg (again)
authorBen Shum <ben@evergreener.net>
Wed, 2 May 2018 22:31:08 +0000 (17:31 -0500)
committerJason Stephenson <jason@sigio.com>
Fri, 8 Mar 2019 14:56:01 +0000 (09:56 -0500)
commita43d967152869a6f2ad5fe4079ef0b7d49cc8ba3
treea820a9d0ae40c0414d42bb4165ab037afb7ed774tree
parent4ab4869d498c48b4808c7ec15ae053b874259151commit | 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>
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/t/search_limit_facet_fetch.pg 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