From d08b279098bc2c7580a8fe4429a737a881ac0a11 Mon Sep 17 00:00:00 2001 From: dbs Date: Mon, 9 Aug 2010 20:43:53 +0000 Subject: [PATCH] SQL 101: Remember to name all of the columns before you insert values into said columns git-svn-id: svn://svn.open-ils.org/ILS/trunk@17142 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/040.schema.asset.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index 72d3a1431..061fa41f5 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -265,7 +265,7 @@ CREATE OR REPLACE FUNCTION asset.label_normalizer_lc(TEXT) RETURNS TEXT AS $func $func$ LANGUAGE PLPERLU; -INSERT INTO asset.call_number_class (name, normalizer) VALUES +INSERT INTO asset.call_number_class (name, normalizer, field) VALUES ('Generic', 'asset.label_normalizer_generic', '050ab,055ab,060ab,070ab,080ab,082ab,086ab,088ab,090,092,096,098,099'), ('Dewey (DDC)', 'asset.label_normalizer_dewey', '080ab,082ab'), ('Library of Congress (LC)', 'asset.label_normalizer_lc', '050ab,055ab') -- 2.11.0