Changeset 24507 for branches/pap_mops/ippTools/share/difftool_skyfile.sql

Timestamp:

Jun 19, 2009, 8:47:32 AM (17 years ago)

Author:

Paul Price

Message:

Fix zero points for exposure time.

File:

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

branches/pap_mops/ippTools/share/difftool_skyfile.sql

@@ -10 +10 @@
     camProcessedExp.zpt_lq,
     camProcessedExp.zpt_uq,
+    rawExp.exp_time,
     rawExp.camera,
     warp1,
@@ -19 +20 @@
 JOIN diffInputSkyfile USING(diff_id, skycell_id)
 JOIN warpRun
-    ON warpRun.warp_id = diffInputSkyfile.warp1 -- NOTE: joining input only!
+-- NOTE: joining input only!
+-- This is so that we can get the correct zero point
+-- XXX This needs to be more clever to handle diffs between stacks
+    ON warpRun.warp_id = diffInputSkyfile.warp1
 JOIN fakeRun USING(fake_id)
 JOIN camRun USING(cam_id)