Delete format within CTE

Answered

Hi, the formatter leaves the query like this:

with deleted_counts as (
delete from counts
where rule_id = gen_random_uuid()
and date between '2022-08-01' and '2022-08-31 23:59'
returning count
)
select *
from deleted_counts;

But I would like to format it like this:

with deleted_counts as (
delete from counts
where rule_id = gen_random_uuid()
and date between '2022-08-01' and '2022-08-31 23:59'
returning count
)
select *
from deleted_counts;

With the same configuration, writing it outside the CTE does work:

delete
from counts
where rule_id = gen_random_uuid()
and date between '2022-08-01' and '2022-08-31 23:59'
returning count;

What configuration would I have to apply so that it remains the same inside the CTE as it was outside?

Current config:

Thanks!

0
1 comment

Hello,

Please see and follow DBE-15318.

1

Please sign in to leave a comment.