How can I use postgres string arrays?

[tasn]

Can't find anything that references them in the code. How do I load them? Query them?

[billy1624]

Hey @tasn, you mean PostgreSQL array in general? It's still work in progress, check

• Support for Vec<impl From<Value>> in models #151
• Bind array values in SQLx PostgreSQL driver sea-query#225
• Implemented 'Array' type for Postgres. sea-query#205

Btw... are you trying to get an array of strings from the db? For example, loading it into a Model like

pub struct Model {
    pub strings: Vec<String>,
    ...
}

[billy1624]

Hey @tasn, sorry, I'm confused. Could you please explain more? The difficulties you face.

[tasn]

Sorry, I was in the midst of battling things. :)

So I tried doing this which didn't work:

        let cond = "some_jsonb_array ??| array [ ?, ? ]";
        query = query.filter(Expr::cust_with_values(&cond, vec![str1, str2]).into_condition());

Though it didn't work, because ? doesn't get translated by seaorm/sqlx when inside a square bracket.

[billy1624]

For PostgreSQL, it use $N (ordered parameters, aka $1, $2, $3 and so on) instead of ?.

[tasn]

cust_with_values (or maybe the query?) automatically transforms ? to $N in other cases (that's why I had to do ??| instead of ?| for example), though not here. Though yeah, I guess I can just manually use $N directly here hoping it doesn't get escaped.

[billy1624]

Yeah, go with $N :D