Error in an sql in laravel

2

I'm having trouble with a sql in the laravel where I make a join, but the error happens even in where , where deleted_at is equal to null , remembering deleted_at is timestamp . In the database is running sql, but not laravel. What is missing? I'm using the postgres database.

The following is the error image:  

    
asked by anonymous 28.08.2014 / 15:30

1 answer

3

Null is not a value, but an "unknown value", so it can not be compared to normal values.

instead of

"tb_combo_produto"."deleted_at" = null

use

whereNull('deleted_at')
    
30.08.2014 / 15:41