Changeset 25201

Timestamp:

Aug 25, 2009, 3:32:26 PM (17 years ago)

Author:

Paul Price

Message:

Need more values out for publishing.

File:

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

branches/pap_mops/ippTools/share/difftool_skyfile.sql

@@ -12 +12 @@
     -- The following are only valid for warps
     -- XXX This needs to be more clever to handle diffs between stacks
+    -- Zero points are appropriate for both forward and backward diffs
     camProcessedInput.zpt_obs,
     camProcessedInput.zpt_stdev,
     camProcessedInput.zpt_lq,
     camProcessedInput.zpt_uq,
-    camProcessedInput.sigma_ra,
-    camProcessedInput.sigma_dec,
     rawInput.exp_time,
     rawInput.camera,
@@ -25 +24 @@
     camInput.cam_id AS cam_id_1,
     fakeInput.fake_id AS fake_id_1,
+    camProcessedInput.sigma_ra_1,
+    camProcessedInput.sigma_dec_1,
     rawTemplate.exp_name AS exp_name_2,
     rawTemplate.exp_id AS exp_id_2,
@@ -30 +31 @@
     camTemplate.cam_id AS cam_id_2,
     fakeTemplate.fake_id AS fake_id_2,
+    camProcessedTemplate.sigma_ra_2,
+    camProcessedTemplate.sigma_dec_2,
 FROM diffRun
 JOIN diffSkyfile USING(diff_id)