projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: d8e092a) | patch
LP#1441750: use string_agg (again) user/bshum/lp1441750
authorBen Shum <ben@evergreener.net>
Wed, 2 May 2018 22:31:08 +0000 (17:31 -0500)
committerBen Shum <ben@evergreener.net>
Thu, 3 May 2018 01:12:06 +0000 (20:12 -0500)
commitd24d0842204821801a94684ab75aa5d75728a35a
treebe9d4e48fa5cfeab1b703c1947e25ad6fb0c5686tree
parentd8e092ac014beee99ca75224a7524d3c0f41690bcommit | 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>
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