Trying to implement composite types postgress: unsupported type X of column #7 ("url")

[lucaswxp]

Hello again.

I'm trying to run the following query:

    // Make a simple query to return the given parameter
    let rows = sqlx::query!(r#"
    SELECT * FROM pc.rakuten_catalog
    "#)
        .fetch_all(&pool)
        .await?;

    println!("rows {:?}", rows);

But I get

error: unsupported type rakuten_url of column #7 ("url")

I tried:

#[derive(Default, PartialEq, Debug, YaSerialize, YaDeserialize, sqlx::Type)]
#[yaserde()]
#[sqlx(type_name = "pc.rakuten_url")]
pub struct Url {
    #[yaserde(rename = "productImage")]
    pub product_image: String,

    #[yaserde(rename = "buy")]
    pub buy: String,
}

But sqlx still can't detect my type, what am I missing?

[jplatte]

See #1004.

[lucaswxp]

Thanks!

This example didn't work:

SELECT url as "url: _" FROM pc.rakuten_catalog

I get columns may not have wildcard overrides in query!()orquery_as!()`, but this one did:

SELECT url as "url: Url" FROM pc.rakuten_catalog

[jplatte]

Right, _ only works for query_as! where the type is inferred from the output struct's field type.