CREATE TABLE delete_test (

id SERIAL PRIMARY KEY,

a INT

a INT,

b text

);

NOTICE: CREATE TABLE will create implicit sequence "delete_test_id_seq" for serial column "delete_test.id"

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "delete_test_pkey" for table "delete_test"

INSERT INTO delete_test (a) VALUES (10);

INSERT INTO delete_test (a) VALUES (50);

INSERT INTO delete_test (a, b) VALUES (50, repeat('x', 10000));

INSERT INTO delete_test (a) VALUES (100);

-- allow an alias to be specified for DELETE's target table

DELETE FROM delete_test AS dt WHERE dt.a > 75;

LINE 1: DELETE FROM delete_test dt WHERE delete_test.a > 25;

^

HINT: Perhaps you meant to reference the table alias "dt".

SELECT* FROM delete_test;

id | a

----+----

1 | 10

2 | 50

SELECTid, a, char_length(b) FROM delete_test;

id | a| char_length

----+----+-------------

1 | 10 |

2 | 50 | 10000

(2 rows)

-- delete a row with a TOASTed value

DELETE FROM delete_test WHERE a > 25;

SELECT id, a, char_length(b) FROM delete_test;

id | a | char_length

----+----+-------------

1 | 10 |

(1 row)

DROP TABLE delete_test;

2 | 3 | values are fun!

(7 rows)

--

-- TOASTed value test

--

insert into inserttest values(30, 50, repeat('x', 10000));

select col1, col2, char_length(col3) from inserttest;

col1 | col2 | char_length

------+------+-------------

| 3 | 7

| 5 | 7

| 5 | 4

| 7 | 7

10 | 20 | 2

-1 | 2 | 7

2 | 3 | 15

30 | 50 | 10000

(8 rows)

drop table inserttest;

LINE 1: UPDATE update_test AS t SET b = update_test.b + 10 WHERE t.a...

^

HINT: Perhaps you meant to reference the table alias "t".

-- Make sure that we can update to a TOASTed value.

UPDATE update_test SET c = repeat('x', 10000) WHERE c = 'car';

SELECT a, b, char_length(c) FROM update_test;

a | b | char_length

-----+----+-------------

100 | 20 |

11 | 41 | 10000

(2 rows)

DROP TABLE update_test;

CREATETABLEdelete_test (

idSERIALPRIMARY KEY,

aINT

aINT,

btext

);

INSERT INTO delete_test (a)VALUES (10);

INSERT INTO delete_test (a)VALUES (50);

INSERT INTO delete_test (a, b)VALUES (50, repeat('x',10000));

INSERT INTO delete_test (a)VALUES (100);

DELETEFROM delete_test dtWHEREdelete_test.a>25;

SELECT*FROM delete_test;

SELECT id, a, char_length(b)FROM delete_test;

DELETEFROM delete_testWHERE a>25;

SELECT id, a, char_length(b)FROM delete_test;

DROPTABLE delete_test;

select*from inserttest;

insert into inserttestvalues(30,50, repeat('x',10000));

select col1, col2, char_length(col3)from inserttest;

droptable inserttest;

UPDATE update_testAS tSET b=update_test.b+10WHEREt.a=10;

UPDATE update_testSET c= repeat('x',10000)WHERE c='car';

SELECT a, b, char_length(c)FROM update_test;

DROPTABLE update_test;