我在WITH语句中做了很多查询,它们应该在一个事务中。我是否需要显式地将我的大查询包含在事务中,还是不必要?
以下是我查询的一个简单示例:
Original Answer翻译成"最初的回答"
WITH
remains_actual AS (
SELECT
...
)
affected_remains AS (
INSERT INTO
...
ON CONFLICT (...) DO UPDATE SET
...
RETURNING
...
)
affected_products AS (
SELECT DISTINCT
...
)
INSERT INTO
....