LTree

[cemoktra]

Is Postgres LTree supported? I dont see any occurences in code or documentation?

[billy1624]

What is the corresponding Rust type of LTree? A String like path?

[cemoktra]

Diesel apparently uses a String

[billy1624]

We depends on db driver sqlx to decode and encode various db types and Rust type. So, it comes down to weather sqlx supports representing LTree Postgres type as String Rust type or not. We haven't test it in our test case. We only tested basic Postgres types.

[billy1624]

You may test it now by changing the Model attribute of the LTree column to String type

[holmofy]

@billy1624 Can it be used like this?

#[derive(Clone, Debug, PartialEq, DeriveEntityModel, Serialize, Deserialize)]
#[sea_orm(table_name = "paper_question")]
pub struct Model {
    #[sea_orm(primary_key, auto_increment = false)]
    pub paper_id: i32,
    #[sea_orm(primary_key, auto_increment = false)]
    pub question_id: i32,
    pub sort: i16,
    #[sea_orm(column_type = "LTree")]
    pub keypoint_path: String,
    #[sea_orm(column_type = "Float")]
    pub correct_ratio: f32,
}

But it reported an error:

Caused by:
    0: Query Error: error returned from database: column "keypoint_path" is of type ltree but expression is of type text
    1: error returned from database: column "keypoint_path" is of type ltree but expression is of type text
    2: error returned from database: column "keypoint_path" is of type ltree but expression is of type text
    3: column "keypoint_path" is of type ltree but expression is of type text