Change #9329
| Category | None |
| Changed by | Ben Shum <ben@evergreener.net> |
| Changed at | Sun 05 Mar 2023 16:31:52 |
| Repository | git://git.evergreen-ils.org/Evergreen.git |
| Project | Evergreen |
| Branch | master |
| Revision | 1c35ee36029aa85e6a04168fc544d5a287638a9a |
Comments
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>
Changed files
- Open-ILS/src/sql/Pg/300.schema.staged_search.sql
- Open-ILS/src/sql/Pg/990.schema.unapi.sql
- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.function-fixes-for-string-agg.sql