Changeset 9445 for trunk/Open-ILS/src/sql/Pg/002.functions.config.sql

Timestamp:

04/23/08 23:02:32 (6 months ago)

Author:

miker

Message:

initial vandelay schema

Files:

• trunk/Open-ILS/src/sql/Pg/002.functions.config.sql (modified) (1 diff)

trunk/Open-ILS/src/sql/Pg/002.functions.config.sql

@@ -40 +40 @@
 
 */
+
+CREATE OR REPLACE FUNCTION public.extract_marc_field ( TEXT, BIGINT, TEXT, TEXT ) RETURNS TEXT AS $$
+    SELECT regexp_replace(array_to_string( array_accum( output ),' ' ),$4,'','g') FROM xpath_table('id', 'marc', $1, $3, 'id='||$2)x(id INT, output TEXT);
+$$ LANGUAGE SQL;
+
+CREATE OR REPLACE FUNCTION public.extract_marc_field ( TEXT, BIGINT, TEXT ) RETURNS TEXT AS $$
+        SELECT public.extract_marc_field($1,$2,$3,'');
+$$ LANGUAGE SQL;
 
 CREATE OR REPLACE FUNCTION oils_i18n_xlate ( keytable TEXT, keyclass TEXT, keycol TEXT, identcol TEXT, keyvalue TEXT, raw_locale TEXT ) RETURNS TEXT AS $func$