How to properly execute DELETE?

Question

PostgreSQL

There is a selection result in the form: (page_id, template_id). It is necessary to perform a delete operation for each result of the previous selection in the form: DELETE FROM table WHERE page_id = ? AND template_id = ?
How can this be done directly in SQL?

Answer 1

DELETE FROM table WHERE (page_id, template_id) IN (SELECT page_id, template_id FROM table WHERE ....)