Timeline for Best way to check for "empty or null value"
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 20, 2023 at 16:47 | comment | added | therealrodk |
I tested this in Postico's SQL Query interface, and it does not work for NULLs.
|
|
| Sep 19, 2022 at 12:43 | comment | added | Automatico |
In postgres, length(NULL) > 0 return NULL, not False.
|
|
| Jul 28, 2021 at 12:01 | comment | added | noonex | I like this solution, just note that is some cases calculating exact length may be relatively expensive operation. | |
| Jun 5, 2020 at 12:15 | comment | added | Kushan Gunasekera |
If you just need to check only empty values, then try this -> where length(stringexpression) = 0;. This works for me.
|
|
| Jan 14, 2020 at 11:58 | comment | added | yglodt | Yes, I did. It does not return empty nor null string fields. | |
| Jan 14, 2020 at 9:45 | comment | added | Flinsch | Did you check this for the NULL case? | |
| Apr 7, 2019 at 19:37 | history | answered | yglodt | CC BY-SA 4.0 |