projects
/
evergreen-equinox.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
Fix functions stranded in the evergreen schema without a search path reference (ugly...
[evergreen-equinox.git]
/
Open-ILS
/
src
/
sql
/
Pg
/
040.schema.asset.sql
diff --git
a/Open-ILS/src/sql/Pg/040.schema.asset.sql
b/Open-ILS/src/sql/Pg/040.schema.asset.sql
index
dbe0c09
..
73a55c4
100644
(file)
--- a/
Open-ILS/src/sql/Pg/040.schema.asset.sql
+++ b/
Open-ILS/src/sql/Pg/040.schema.asset.sql
@@
-289,7
+289,7
@@
INSERT INTO asset.call_number_class (name, normalizer, field) VALUES
CREATE OR REPLACE FUNCTION asset.normalize_affix_sortkey () RETURNS TRIGGER AS $$
BEGIN
NEW.label_sortkey := REGEXP_REPLACE(
- lpad_number_substrings(
+ evergreen.lpad_number_substrings(
naco_normalize(NEW.label),
'0',
10