projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 81818c8) | patch
LP#789747 - Use native functions instead of SQL functions
authorDan Scott <dan@coffeecode.net>
Sun, 29 May 2011 03:51:49 +0000 (23:51 -0400)
committerThomas Berezansky <tsbere@mvlc.org>
Sun, 29 May 2011 13:01:21 +0000 (09:01 -0400)
commit6170b240102440f2d836bd6f80533da7da5ef620
tree132415df4fb9f41d9168d3ddf0a284c298de85edtree
parent81818c81a1df25ded485329195c9a40b960c05bdcommit | 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>
Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
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