rolling back recent change ... miscommunication on how i18n_core is used
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 20 Aug 2008 04:45:04 +0000 (04:45 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 20 Aug 2008 04:45:04 +0000 (04:45 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@10377 dcc99617-32d9-48b4-a31d-7c20da2025e4

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

index 998274b..42935aa 100644 (file)
@@ -78,7 +78,7 @@ BEGIN
     -- Try the full locale
     SELECT  * INTO result
       FROM  config.i18n_core
     -- Try the full locale
     SELECT  * INTO result
       FROM  config.i18n_core
-      WHERE (fq_field = keyfield OR fq_field = keytable)
+      WHERE fq_field = keyfield
             AND identity_value = keyvalue
             AND translation = locale;
 
             AND identity_value = keyvalue
             AND translation = locale;
 
@@ -86,7 +86,7 @@ BEGIN
     IF NOT FOUND THEN
         SELECT  * INTO result
           FROM  config.i18n_core
     IF NOT FOUND THEN
         SELECT  * INTO result
           FROM  config.i18n_core
-          WHERE (fq_field = keyfield OR fq_field = keytable)
+          WHERE fq_field = keyfield
                 AND identity_value = keyvalue
                 AND translation = language;
     END IF;
                 AND identity_value = keyvalue
                 AND translation = language;
     END IF;