Postgresql JSON operators (->, ->>, @>) doesn't work in sqlx?

help
1

Hi,

Does anyone know how to use the native Postgresql operators with sqlx?

Not sure, why but the Postgresql JSON operators don't seem to work in a query but works fine with psql.

sql::query_as( SELECT info -> 'customer' FROM table; );

Is this not supported or is there another syntax to achieve this?

Thanks

2

Have you enabled the json feature flag for sqlx?

3

Yes I have it in my Cargo.toml.

sqlx = { version = “0.5.10”, features = [“runtime-tokio-rustls”, “postgres”, “uuid”, “time”, “any”, “json”]}
4

Found the problem. I was mapping to the wrong type. It’s working now.

5

This topic was automatically closed 90 days after the last reply. We invite you to open a new topic if you have further questions or comments.