projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: ad711cc) | patch
LP#789747 - Use native functions instead of SQL functions user/dbs/native-array-functions_2_1
authorDan Scott <dan@coffeecode.net>
Sun, 29 May 2011 03:51:49 +0000 (23:51 -0400)
committerDan Scott <dan@coffeecode.net>
Sun, 29 May 2011 04:22:46 +0000 (00:22 -0400)
commit0eae7af475fdbb974f7c43128dc9fda68f1ec5c5
tree4e7be381dd6e33d635da12da9c378188e9e7726btree
parentad711cc0e526165679ccac50c1ec1e0a8bd31564commit | diff
LP#789747 - Use native functions instead of SQL functions

There are two functions native to PostgreSQL since at least 8.4
for which Evergreen is currently using custom SQL functions:

  * array_agg() - array_accum()
  * unnest() - search.explode_array() and public.explode_array()

Swap'em out across the board.

Signed-off-by: Dan Scott <dan@coffeecode.net>
14 files changed:
Open-ILS/examples/build-eg-replication.sh diff | blob | history
Open-ILS/examples/fm_IDL.xml diff | blob | history
Open-ILS/src/perlmods/lib/OpenILS/Application/Booking.pm diff | blob | history
Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm diff | blob | history
Open-ILS/src/sql/Pg/002.functions.config.sql diff | blob | history
Open-ILS/src/sql/Pg/030.schema.metabib.sql diff | blob | history
Open-ILS/src/sql/Pg/100.circ_matrix.sql diff | blob | history
Open-ILS/src/sql/Pg/110.hold_matrix.sql diff | blob | history
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/999.functions.global.sql diff | blob | history
Open-ILS/src/sql/Pg/example.reporter-extension.sql diff | blob | history
Open-ILS/src/sql/Pg/pgmemcache-ou_tree_traversal_cache.sql diff | blob | history
Open-ILS/src/sql/Pg/reporter-schema.sql diff | blob | history
Evergreen ILS