Is it possible to `DELETE` in a subquery?
You can DELETE in a CTE - which is a different kind of subquery. 

But you probably don't need it for this simple case, you just need to use RETURNING and fix the syntax errors in your code:

DELETE 
FROM posts AS p
WHERE p.title = 'whoops'
RETURNING p.* ;