From 791fa598afcd59f8f6b1f28fa2d198ba5be8d583 Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 25 Apr 2011 18:42:11 +0000 Subject: [PATCH] Regression in pulling physical characteristics from a record in an SVF world, spotted by Jason Stephenson git-svn-id: svn://svn.open-ils.org/ILS/trunk@20306 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index 9e8272f5c1..a33dd69283 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -1065,9 +1065,10 @@ BEGIN attr_value := oils_xpath_string(attr_def.xpath, transformed_xml, COALESCE(attr_def.joiner,' '), ARRAY[ARRAY[xfrm.prefix, xfrm.namespace_uri]]); ELSIF attr_def.phys_char_sf IS NOT NULL THEN -- a named Physical Characteristic, see config.marc21_physical_characteristic_*_map - SELECT value::TEXT INTO attr_value - FROM biblio.marc21_physical_characteristics(NEW.id) - WHERE subfield = attr_def.phys_char_sf + SELECT m.value INTO attr_value + FROM biblio.marc21_physical_characteristics(NEW.id) v + config.marc21_physical_characteristic_value_map m ON (m.id = v.value) + WHERE v.subfield = attr_def.phys_char_sf LIMIT 1; -- Just in case ... END IF; -- 2.43.2