LP1820339: Vandelay Imports on Pg 10 user/jboyer/lp1820339_pg10_vandelay
authorJason Boyer <jboyer@library.in.gov>
Fri, 15 Mar 2019 19:35:26 +0000 (15:35 -0400)
committerJason Boyer <jboyer@library.in.gov>
Fri, 15 Mar 2019 19:38:22 +0000 (15:38 -0400)
commit9073fe30658f6a84464e9f074957add48557f541
tree51f821253904c89f4cfe2af7951ca9fa501e5b3d
parentdf8973b3a98c84881544f340b0b5e4373f705822
LP1820339: Vandelay Imports on Pg 10

In vandelay.flatten_marc_hstore there are a couple
instances of set-returning functions used inside a
CASE statement, which Pg10 is unhappy about. This
branch changes these regexp_matches calls to use
regexp_match instead which avoids this error.

Signed-off-by: Jason Boyer <jboyer@library.in.gov>
Open-ILS/src/sql/Pg/012.schema.vandelay.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1820339-pg10-vandelay.sql [new file with mode: 0644]