|< < 13 > >|

Delete

Example


delete from T
where x between 50 and 80;

DELETE 4

Modified state


 k | x  |  y   |       z       
---+----+------+---------------
 2 |    |    0 | 
 1 | 10 | 1111 | hello
 3 | 30 | 1000 | 
 5 | 50 |  555 | make
 6 | 60 |  666 | america
 7 | 70 |  777 | irate
 8 | 80 |  888 | again
 4 | 40 | 1444 | for four fore
(4 rows)

|< < 13 > >|