1CREATE TABLE delete_test (
2    id SERIAL PRIMARY KEY,
3    a INT,
4    b text
5);
6
7INSERT INTO delete_test (a) VALUES (10);
8INSERT INTO delete_test (a, b) VALUES (50, repeat('x', 10000));
9INSERT INTO delete_test (a) VALUES (100);
10
11-- allow an alias to be specified for DELETE's target table
12DELETE FROM delete_test AS dt WHERE dt.a > 75;
13
14-- if an alias is specified, don't allow the original table name
15-- to be referenced
16DELETE FROM delete_test dt WHERE delete_test.a > 25;
17
18SELECT id, a, char_length(b) FROM delete_test;
19
20-- delete a row with a TOASTed value
21DELETE FROM delete_test WHERE a > 25;
22
23SELECT id, a, char_length(b) FROM delete_test;
24
25DROP TABLE delete_test;
26