PG `ilike` does not support Nullable<Text>

[carlosdp]

Setup

Versions

• Rust: 1.28.0 stable
• Diesel: 1.2.2
• Database: Postgres
• Operating System Mac OS

Feature Flags

• diesel: postgres

Problem Description

PG ilike does not support Nullable

What are you trying to accomplish?

Use ilike text expression method on a nullable text field

What is the expected output?

It compiles

What is the actual output?

ilike is not implemented for Nullable<Text>

Are you seeing any additional errors?

No

Steps to reproduce

pub struct User {
  pub name: Option<String>,
}
...
users::table.filter(name.ilike("%test%")).get_result<User>()?;

Checklist

• I have already looked over the issue tracker for similar issues.
• This issue can be reproduced on Rust's stable channel. (Your issue will be
  closed if this is not the case)