LP1820339: Vandelay Imports on Pg 10
authorJason Boyer <jboyer@library.in.gov>
Fri, 15 Mar 2019 19:35:26 +0000 (15:35 -0400)
committerJason Boyer <jboyer@library.in.gov>
Wed, 8 May 2019 14:18:56 +0000 (10:18 -0400)
commit4ce058763027e724ee2bfc3b339a0dc77ad61107
tree90a553433fe5083e8fe035f3fe73faecfcd1e9f9
parente5ba0eddecddb398f7b8f4f980b5dd0f126024b8
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>
Signed-off-by: Jason Stephenson <jason@sigio.com>
Signed-off-by: Ben Shum <ben@evergreener.net>
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]