search

tpetry / laravel-postgresql-enhanced

Support for many missing PostgreSQL specific features
MIT License
772 stars 31 forks source link

Support `whereIsDistinctFrom` and `whereNotIsDistinctFrom` #39

Open tpetry opened 2 years ago

tpetry commented 2 years ago

The IS DISTINCT FROM and IS NOT DISTINCT FROM terms simplify a query a lot for nullable columns:

col IS DISTINCT FROM 'value' simplifies a query with nullable columns as it is a replacement for (col IS NULL OR col != 'value')