DeleteSimilar to update, use a predicate to identify the rows to be deleted. Scripts: delete.sql. ExampleStarting state
select * from T;
k | x | y | z
---+----+------+---------------
2 | | 0 |
5 | 50 | 555 | make
6 | 60 | 666 | america
7 | 70 | 777 | irate
8 | 80 | 888 | again
1 | 10 | 1111 | hello
3 | 30 | 1000 |
4 | 40 | 1444 | for four fore
(8 rows)
|