actually test for transcendance, not just for a source
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 18 Mar 2008 04:02:21 +0000 (04:02 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 18 Mar 2008 04:02:21 +0000 (04:02 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@9065 dcc99617-32d9-48b4-a31d-7c20da2025e4

Open-ILS/src/sql/Pg/300.schema.staged_search.sql

index cb8de81..89d1f78 100644 (file)
@@ -364,7 +364,12 @@ BEGIN
             CONTINUE;
         END IF;
 
-        PERFORM 1 FROM biblio.record_entry b JOIN config.bib_source s ON (b.source = s.id) WHERE b.id IN ( SELECT * FROM search.explode_array( core_result.records ) );
+        PERFORM 1
+          FROM  biblio.record_entry b
+                JOIN config.bib_source s ON (b.source = s.id)
+          WHERE s.transcendant
+                AND b.id IN ( SELECT * FROM search.explode_array( core_result.records ) );
+
         IF FOUND THEN
             -- RAISE NOTICE ' % were all transcendant ... ', core_result.records;
             visible_count := visible_count + 1;