Re: Delete in IF or CASE function

[Peter Brawley]

If ...Where x=y... is the base deletion condition, then here's one way ...

delete from input
where x=y and signal_id=0
and exists( select 1 from input where x=y and signal_id=1 );

If what that's doing isn't clear, inspect the result of ...

select x, y, signal_id from input
where x=y and signal_id=0
and exists( select 1 from input where x=y and signal_id=1 );