Witam,
Czy mozna przepisac takie zapytanie na bezpieczniejsze? I szybsze?
WITH _customers_ AS (
SELECT u.user_id
FROM users u
JOIN orders o ON o.user_id = u.user_id
JOIN order_items oi ON oi.order_id = o.order_id
WHERE u.user_id = 9999
),
_del1_ AS (
DELETE FROM table_1 AS a
USING _customers_
WHERE _customers_.user_id = a.user_id
RETURNING *
),
_del2_ AS (
DELETE FROM table_2 AS a
USING _customers_
WHERE _customers_.user_id = a.user_id
RETURNING *
)
SELECT * FROM _del1_ LIMIT 1;