error occurred while decoding column "teams": unexpected null; try decoding as an Option

[frederikhors]

I'm using a query like this:

SELECT
	"player".*,
	( SELECT ARRAY_AGG ( team ) FROM "team" WHERE "team".player_id = "player"."id" ) AS teams,
FROM
	"player" 
WHERE
	"player"."id" = '1'

It returns:

id | name | ... | teams

1  | John | ... | NULL

But sqlx throws with:

error occurred while decoding column "teams": unexpected null; try decoding as an "Option"

Why?

The Rust code is:

#[derive(Debug, Default)]
pub struct PgPlayer {
    pub id: String,
    pub created_at: time::OffsetDateTime,
    pub teams: Option<Vec<PgTeam>>,
}

impl sqlx::FromRow<'_, sqlx::postgres::PgRow> for PgPlayer {
    fn from_row(row: &sqlx::postgres::PgRow) -> sqlx::Result<Self> {
        Ok(Self {
            id: row.get("id"),
            created_at: row.get("created_at"),
            teams: if row.try_get_raw("teams").is_ok() {
                Some(
                    row.try_get::<Vec<Option<PgTeam>>, &str>("teams")?
                        .into_iter()
                        .flatten()
                        .collect(),
                )
            } else {
                None
            },
        })
    }
}

Why the error?