1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
DELETE FROM films;
DELETE FROM ONLY films;
DELETE FROM films *;
DELETE FROM films AS f;
DELETE FROM films f;
DELETE FROM films USING producers
WHERE producer_id = producers.id AND producers.name = 'foo';
DELETE FROM films AS f USING producers AS p
WHERE f.producer_id = p.id AND p.name = 'foo';
DELETE FROM films AS f USING producers AS p, actors AS a
WHERE f.producer_id = p.id AND p.name = 'foo'
AND f.actor_id = a.id AND a.name = 'joe cool';
DELETE FROM films f USING producers p
WHERE f.producer_id = p.id AND p.name = 'foo';
DELETE FROM films f USING producers p, actors a
WHERE f.producer_id = p.id AND p.name = 'foo'
AND f.actor_id = a.id AND a.name = 'joe cool';
DELETE FROM tasks WHERE CURRENT OF c_tasks;
DELETE FROM films WHERE kind <> 'Musical';
DELETE FROM tasks WHERE status = 'DONE' RETURNING *;
DELETE FROM tasks WHERE status = 'DONE' RETURNING actor_id;
DELETE FROM tasks WHERE status = 'DONE' RETURNING actor_id as a_id;
DELETE FROM tasks WHERE status = 'DONE' RETURNING actor_id a_id;
DELETE FROM tasks WHERE status = 'DONE' RETURNING actor_id, producer_id;
DELETE FROM tasks WHERE status = 'DONE' RETURNING actor_id as a_id, producer_id as p_id;
DELETE FROM tasks WHERE status = 'DONE' RETURNING actor_id a_id, producer_id p_id;
WITH test as (select foo from bar)
DELETE FROM films;
WITH RECURSIVE t(n) AS (
VALUES (1)
UNION ALL
SELECT n+1 FROM t WHERE n < 100
)
DELETE FROM films;
DELETE FROM foo USING baz
LEFT JOIN bar ON baz.bar_id = bar.id
WHERE foo.id = bar.foo_id
AND baz.id = 'c';
|
