From a8386dfa7cfe95460794537e1baa35165a53dfb9 Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 15 Apr 2008 14:11:30 +0000 Subject: [PATCH] updating dewey extractor git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_2@9361 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/020.schema.functions.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/020.schema.functions.sql b/Open-ILS/src/sql/Pg/020.schema.functions.sql index 2e802933de..50a0cacdee 100644 --- a/Open-ILS/src/sql/Pg/020.schema.functions.sql +++ b/Open-ILS/src/sql/Pg/020.schema.functions.sql @@ -21,12 +21,12 @@ CREATE OR REPLACE FUNCTION public.call_number_dewey( TEXT ) RETURNS TEXT AS $$ $txt =~ s/^\s+//o; $txt =~ s/[\[\]\{\}\(\)`'"#<>\*\?\-\+\$\\]+//o; $txt =~ s/\s+$//o; - if (/(\d{3}(?:\.\d+)?)/o) { + if ($txt =~ /(\d{3}(?:\.\d+)?)/o) { return $1; } else { return (split /\s+/, $txt)[0]; } -$$ LANGUAGE 'plperl' STRICT IMMUTABLE; +$$ LANGUAGE 'plperlu' STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION public.call_number_dewey( TEXT, INT ) RETURNS TEXT AS $$ SELECT SUBSTRING(call_number_dewey($1) FROM 1 FOR $2); -- 2.11.0