How do I create a table with a DATE
My migration is

CREATE TABLE posts (
    id SERIAL NOT NULL PRIMARY KEY,
    title TEXT NOT NULL,
    images INTEGER[] NOT NULL,
    content TEXT NOT NULL,
    posttime TIMESTAMPTZ NOT NULL
)

and my model is

#[derive(Debug, Insertable)]
#[table_name="posts"]
pub struct NewPost<'x> {
    pub title: &'x str,
    pub images: Vec<i32>,
    pub content: &'x str,
    pub posttime: NaiveDateTime,
}

diesel migration redo generates

table! {
    posts (id) {
        id -> Int4,
        title -> Text,
        images -> Array<Int4>,
        content -> Text,
        posttime -> Date,
    }
}

but when I try to run cargo run i get this error

error[E0277]: the trait bound `NaiveDateTime: diesel::Expression` is not satisfied
  --> src/models.rs:17:17
   |
17 | #[derive(Debug, Insertable)]
   |                 ^^^^^^^^^^ the trait `diesel::Expression` is not implemented for `NaiveDateTime`
   |
   = note: required because of the requirements on the impl of `diesel::Expression` for `&NaiveDateTime`
   = note: required because of the requirements on the impl of `AsExpression<diesel::sql_types::Date>` for `&NaiveDateTime`
   = note: this error originates in the derive macro `Insertable` (in Nightly builds, run with -Z macro-backtrace for more info)

How do I create a table with a DATE
My migration is

CREATE TABLE posts (
    id SERIAL NOT NULL PRIMARY KEY,
    title TEXT NOT NULL,
    images INTEGER[] NOT NULL,
    content TEXT NOT NULL,
    posttime TIMESTAMPTZ NOT NULL
)

and my model is

#[derive(Debug, Insertable)]
#[table_name="posts"]
pub struct NewPost<'x> {
    pub title: &'x str,
    pub images: Vec<i32>,
    pub content: &'x str,
    pub posttime: NaiveDateTime,
}

diesel migration redo generates

table! {
    posts (id) {
        id -> Int4,
        title -> Text,
        images -> Array<Int4>,
        content -> Text,
        posttime -> Date,
    }
}

but when I try to run cargo run i get this error

error[E0277]: the trait bound `NaiveDateTime: diesel::Expression` is not satisfied
  --> src/models.rs:17:17
   |
17 | #[derive(Debug, Insertable)]
   |                 ^^^^^^^^^^ the trait `diesel::Expression` is not implemented for `NaiveDateTime`
   |
   = note: required because of the requirements on the impl of `diesel::Expression` for `&NaiveDateTime`
   = note: required because of the requirements on the impl of `AsExpression<diesel::sql_types::Date>` for `&NaiveDateTime`
   = note: this error originates in the derive macro `Insertable` (in Nightly builds, run with -Z macro-backtrace for more info)

How do I create a table with a DATE
My migration is

CREATE TABLE posts (
    id SERIAL NOT NULL PRIMARY KEY,
    title TEXT NOT NULL,
    images INTEGER[] NOT NULL,
    content TEXT NOT NULL,
    posttime TIMESTAMPTZ NOT NULL
)

and my model is

#[derive(Debug, Insertable)]
#[table_name="posts"]
pub struct NewPost<'x> {
    pub title: &'x str,
    pub images: Vec<i32>,
    pub content: &'x str,
    pub posttime: NaiveDateTime,
}

diesel migration redo generates

table! {
    posts (id) {
        id -> Int4,
        title -> Text,
        images -> Array<Int4>,
        content -> Text,
        posttime -> Date,
    }
}

but when I try to run cargo run i get this error

error[E0277]: the trait bound `NaiveDateTime: diesel::Expression` is not satisfied
  --> src/models.rs:17:17
   |
17 | #[derive(Debug, Insertable)]
   |                 ^^^^^^^^^^ the trait `diesel::Expression` is not implemented for `NaiveDateTime`
   |
   = note: required because of the requirements on the impl of `diesel::Expression` for `&NaiveDateTime`
   = note: required because of the requirements on the impl of `AsExpression<diesel::sql_types::Date>` for `&NaiveDateTime`
   = note: this error originates in the derive macro `Insertable` (in Nightly builds, run with -Z macro-backtrace for more info)

Sorry to ask again, as i have another problem which i cannot seem to get a nice way around:
I have in the segmentation system a value that requires the query to have the possiblility of multiple filters eg

SELECT * FROM table WHERE ( table.a = xxx AND table.b = yyy AND table.c = zzz ... N ) OR ( ... )

where 1 or more of the (xxx, yyy, zzz ... N ) maybe None

I am trying to figure out a clean way to do a BoxedExpression to add the expression in a for loop.

let mut expr: Box<BoxableExpression<dsl::Metadata, _, SqlType = Bool>> = Box::new(val_init);

for (val) in stack {
    if some_condition {
        expr = expr.or(val);
    }
}

Basically I cannot figure out how to initialize the boxed expression and then append all the expression in order.

Sorry to ask again, as i have another problem which i cannot seem to get a nice way around:
I have in the segmentation system a value that requires the query to have the possiblility of multiple filters eg

SELECT * FROM table WHERE ( table.a = xxx AND table.b = yyy AND table.c = zzz ... N ) OR ( ... )

where 1 or more of the (xxx, yyy, zzz ... N ) maybe None

I am trying to figure out a clean way to do a BoxedExpression to add the expression in a for loop.

let mut expr: Box<BoxableExpression<dsl::Metadata, _, SqlType = Bool>> = Box::new(val_init);

for (val) in stack {
    if some_condition {
        expr = expr.or(val);
    }
}

Basically I cannot figure out how to initialize the boxed expression and then append all the expression in order.

Sorry to ask again, as i have another problem which i cannot seem to get a nice way around:
I have in the segmentation system a value that requires the query to have the possiblility of multiple filters eg

SELECT * FROM table WHERE ( table.a = xxx AND table.b = yyy AND table.c = zzz ... N ) OR ( ... )

where 1 or more of the (xxx, yyy, zzz ... N ) maybe None

I am trying to figure out a clean way to do a BoxedExpression to add the expression in a for loop.

let mut expr: Box<BoxableExpression<dsl::Metadata, _, SqlType = Bool>> = Box::new(val_init);

for (val) in stack {
    if some_condition {
        expr = expr.or(val);
    }
}

Basically I cannot figure out how to initialize the boxed expression and then append all the expression in order.