How to query Postgres TimestampTZ[], Enum and TSVector datatypes?

[elasmojs]

Hi it would be great to have an example of which Rust data type is compatible with Postgres Numeric, Text[] and TSVector datatypes.

edit: I want to use "row.try_get" to retrieve the value of the column

let res:Result<BigDecimal, Error> = row.try_get(col.name.as_str());

throws compile error

the trait 'sqlx_core::decode::Decode<'_, sqlx_core::postgres::database::Postgres>' is not implemented for 'bigdecimal::BigDecimal'

thanks

[elasmojs]

Have figured this out now, one has to use sqlx::types::BigDecimal instead of bigdecimal::BigDecimal, it would be great if there can be a note for the same in the documentation or an example.

Any help with the other data types Text[], TSVector and Enum would be greatly appreciated. Thanks

[elasmojs]

Have figured it out for arrays now, you need to use

let res:Result<Vec<YOUR_DATATYPE>, Error> = row.try_get(col.name.as_str());

This however does not work for TimestampTZ[] for the following code, it returns an error;

let res:Result<Vec<chrono::DateTime<chrono::Utc>, Error> = row.try_get(col.name.as_str());

mismatched types; Rust type 'alloc::vec::Vec<chrono::datetime::DateTime<chrono::offset::utc::Utc>>' (as SQL type TIMESTAMP[]) is not compatible with SQL type TIMESTAMPTZ[]

thanks

[abonander]

@elasmojs if you get an error about bigdecimal::BigDecimal not implementing Decode, then you have the wrong version of bigdecimal; make sure it's the same as in sqlx-core/Cargo.toml. However, it looks like you found the alternative of just using our reexport.

The issue with DateTime not decoding as TimestampTZ[] has been fixed as of 0.4.0-beta.1.

Support for TSVector is not yet implemented.

[elasmojs]

@abonander thank you for the response. It really helps. I am closing this now.

[OutOfBoundCats]

@abonander Any idea when TSVector will be implemented for Postgres

[abonander]

Feel free to open a PR.