9 CASE WHEN :application IS NULL THEN '' ELSE :application END,
10 CASE WHEN :description IS NULL THEN '' ELSE :description END,
11 COALESCE(:manuallyAdded, false)
12 ) ON CONFLICT (scope) DO UPDATE
14 application
= COALESCE(:application, EXCLUDED.application
),
15 description
= COALESCE(:description, EXCLUDED.description
),
16 is_manually_added
= EXCLUDED.is_manually_added
OR COALESCE(:manuallyAdded, false)