Question about RLS policy

I'd like to setup RLS policy only indicating that a row is allowed to delete when a referred row (by a foreign key) is deleted.

For example, I have two table, one is user. another is article
When a row in a user table is deleted, I want to allow the article table to delete all the rows connected by a foreign key with the user.

How do you write the USING expression??
Was this page helpful?