From c7bb949d86e147e9051877497327626ef86cb569 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Fri, 13 Jan 2017 14:28:24 -0500 Subject: [PATCH] make authority.extract_headings return the field ID Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/upgrade/YYYY.schema.authority.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.authority.sql b/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.authority.sql index bea89b604f..e49890bc43 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.authority.sql +++ b/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.authority.sql @@ -91,6 +91,7 @@ SELECT id, 1, 0 FROM authority.heading_field; CREATE TYPE authority.heading AS ( + field INT, type authority.heading_type, purpose authority.heading_purpose, variant_type authority.variant_heading_type, @@ -127,6 +128,7 @@ BEGIN -- Loop over the indexing entries FOR idx IN SELECT * FROM authority.heading_field ORDER BY format LOOP + output_row.field := idx.id; output_row.type := idx.heading_type; output_row.purpose := idx.heading_purpose; -- 2.11.0