fixing on mung_sf9 where it declares int instead of bigint for bib ids

[migration-tools.git] / sql / base / 01-marc.sql

diff --git a/sql/base/01-marc.sql b/sql/base/01-marc.sql
index 483d8d4..b44b6de 100644 (file)
--- a/sql/base/01-marc.sql
+++ b/sql/base/01-marc.sql
@@ -429,8 +429,8 @@ CREATE OR REPLACE FUNCTION migration_tools.get_marc_tags_filtered (TEXT, TEXT, T
     return \@texts;
 $$ LANGUAGE PLPERLU STABLE;
 
-DROP FUNCTION IF EXISTS migration_tools.munge_sf9(INTEGER,TEXT,TEXT);
-CREATE OR REPLACE FUNCTION migration_tools.merge_sf9(bib_id INTEGER,new_sf9 TEXT,force TEXT DEFAULT 'false')
+DROP FUNCTION IF EXISTS migration_tools.munge_sf9(BIGINT,TEXT,TEXT);
+CREATE OR REPLACE FUNCTION migration_tools.merge_sf9(bib_id BIGINT,new_sf9 TEXT,force TEXT DEFAULT 'false')
     RETURNS BOOLEAN AS
 $BODY$
 DECLARE