]> git.evergreen-ils.org Git - working/Evergreen.git/commit
projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 2c16628) | 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:12:24 +0000 (09:12 -0500)
commitd4ad2bcdf13c6244c9e6d02ca1546a8c75272221
tree5e40ca4ec3c6a6b9cd1e5cba2834fabea37dedc2tree
parent2c16628b0b29215bc7f7526f800f02b976b645a4commit | 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