[Question] How should I bind a Vec as a parameter of IN ?

[TENX-S]

Table:

CREATE TABLE IF NOT EXISTS posts (
    id                  BIGSERIAL PRIMARY KEY,
    title               TEXT NOT NULL
);

The rust part

let title = vec!["A", "B"];
let posts = sqlx::query(r#"
    SELECT * FROM posts
    WHERE title NOT IN ($1);
"#).bind(title).map( || {...}).fetch_all(&db_pool).await?;

The error output:

Database(PgDatabaseError { severity: Error, code: "42883", message: "operator does not exist: text <> text[]", detail: None, hint:
Some("No operator matches the given name and argument type(s). You might need to add explicit type casts."), position: 
Some(Original(46)), where: None, schema: None, table: None, column: None, data_type: None, constraint: None, file: 
Some("parse_oper.c"), line: Some(721), routine: Some("op_error") })', src/grpc/command.rs:111:14,

How should I fix it ? Thank you !

[TENX-S]

Close this as a duplicate of #875

[Matrix-Zhang]

Close this as a duplicate of #875

how to fix ?

[abonander]

This is covered in the FAQ now: https://github.com/launchbadge/sqlx/blob/master/FAQ.md#how-can-i-do-a-select--where-foo-in--query