如何在迪塞尔中对Postgres数据库执行delete with子查询？

#[macro_use]
extern crate diesel;

use diesel::prelude::*;
use diesel::pg::PgConnection;

table! {
    posts (id) {
        id -> Integer,
        title -> Text,
        body -> Text,
    }
}

fn delete_posts_with_subquery(conn: &PgConnection) -> QueryResult<usize> {
    use self::posts::dsl::*;

    let subquery = posts.filter(title.eq("example")).select(id);

    diesel::delete(posts.filter(id.eq_any(subquery)))
        .execute(conn)
}

fn main() {
    let database_url = "postgres://username:password@localhost/mydatabase";
    let conn = PgConnection::establish(&database_url).expect("Failed to connect to database");

    match delete_posts_with_subquery(&conn) {
        Ok(deleted_rows) => println!("Deleted {} rows", deleted_rows),
        Err(err) => eprintln!("Error deleting posts: {}", err),
    }
}