From 87e652e61cea3b14206ce3b7bf28c0235c41146e Mon Sep 17 00:00:00 2001
From: Chris Sharp <csharp@georgialibraries.org>
Date: Sat, 8 Sep 2018 16:36:36 -0400
Subject: [PATCH] add pre-3.2-upgrade script

---
 .../src/sql/Pg/version-upgrade/pines-pre-3.2-upgrade.sql   | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/pines-pre-3.2-upgrade.sql

diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-3.2-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-3.2-upgrade.sql
new file mode 100644
index 0000000000..fea5a50919
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-3.2-upgrade.sql
@@ -0,0 +1,14 @@
+begin;
+
+drop function if exists public.oils_json_to_text(text);
+
+CREATE OR REPLACE FUNCTION evergreen.oils_json_to_text( TEXT ) RETURNS TEXT AS $f$
+    use JSON::XS;
+    my $json = shift();
+    my $txt;
+    eval { $txt = JSON::XS->new->allow_nonref->decode( $json ) };
+    return undef if ($@);
+    return $txt
+$f$ LANGUAGE PLPERLU;
+
+commit;
-- 
2.11.0