Changeset 18949 for trunk/ippTools/share/difftool_skyfile.sql

Timestamp:

Aug 7, 2008, 5:40:18 PM (18 years ago)

Author:

bills

Message:

For mode -diffskyfile don't require state to be run, output the state

File:

• trunk/ippTools/share/difftool_skyfile.sql (modified) (2 diffs)

trunk/ippTools/share/difftool_skyfile.sql

@@ -2 +2 @@
     diffRun.skycell_id,
     diffRun.tess_id,
+    diffRun.state,
     diffSkyfile.*
 FROM diffRun
@@ -7 +8 @@
     USING(diff_id)
 WHERE
-    diffRun.state = 'run'
+    -- bogus test to allow appending conditionals
+    WHERE diffRun.diff_id IS NOT NULL