IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Jan 19, 2024, 8:12:15 AM (2 years ago)
Author:
eugene
Message:

working on xcfftool

File:
1 edited

Legend:

Unmodified
Added
Removed

  • branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_revert.sql

    r42587 r42596  
    1 DELETE FROM fullForceResult
    2 USING fullForceResult, fullForceRun, xccalRun, stackRun, skycell
    3 WHERE fullForceRun.ff_id = fullForceResult.ff_id
    4     AND fullForceResult.fault != 0
    5     AND fullForceRun.xccal_id = xccalRun.xccal_id
    6     AND xccalRun.stack_id = stackRun.stack_id
    7     AND stackRun.tess_id = skycell.tess_id AND stackRun.skycell_id =  skycell.skycell_id
     1DELETE FROM xcForceResult
     2USING xcForceResult, xcForceRun
     3WHERE xcForceRun.xcff_id = xcForceResult.xcff_id
     4    AND xcForceResult.fault != 0
Note: See TracChangeset for help on using the changeset viewer.