1CREATE TABLE delete_test ( 2 id SERIAL PRIMARY KEY, 3 a INT, 4 b text 5); 6INSERT INTO delete_test (a) VALUES (10); 7INSERT INTO delete_test (a, b) VALUES (50, repeat('x', 10000)); 8INSERT INTO delete_test (a) VALUES (100); 9-- allow an alias to be specified for DELETE's target table 10DELETE FROM delete_test AS dt WHERE dt.a > 75; 11-- if an alias is specified, don't allow the original table name 12-- to be referenced 13DELETE FROM delete_test dt WHERE delete_test.a > 25; 14ERROR: invalid reference to FROM-clause entry for table "delete_test" 15LINE 1: DELETE FROM delete_test dt WHERE delete_test.a > 25; 16 ^ 17HINT: Perhaps you meant to reference the table alias "dt". 18SELECT id, a, char_length(b) FROM delete_test; 19 id | a | char_length 20----+----+------------- 21 1 | 10 | 22 2 | 50 | 10000 23(2 rows) 24 25-- delete a row with a TOASTed value 26DELETE FROM delete_test WHERE a > 25; 27SELECT id, a, char_length(b) FROM delete_test; 28 id | a | char_length 29----+----+------------- 30 1 | 10 | 31(1 row) 32 33DROP TABLE delete_test; 34