Skip to content

Add nullif(value1, value2).#1429

Description

@igalklebanov

Hey 馃憢

Essentially, it's a shorthand for:

eb
  .case()
  .when('col1', '=', eb.ref('col2'))
  .then(null)
  .else(eb.ref('col1'))
  .end()

and exists in all major databases.

Metadata

Metadata

Assignees

Labels

apiRelated to library's APIenhancementNew feature or requestmssqlRelated to MS SQL Server (MSSQL)mysqlRelated to MySQLoracleRelated to OraclepostgresRelated to PostgreSQLsqliteRelated to sqlite

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions