is_null.asciidoc 568 B

1234567891011121314151617181920212223
  1. [[esql-is_null]]
  2. === `IS_NULL`
  3. Returns a boolean that indicates whether its input is `null`.
  4. [source.merge.styled,esql]
  5. ----
  6. include::{esql-specs}/docs.csv-spec[tag=isNull]
  7. ----
  8. [%header.monospaced.styled,format=dsv,separator=|]
  9. |===
  10. include::{esql-specs}/docs.csv-spec[tag=isNull-result]
  11. |===
  12. Combine this function with `NOT` to filter out any `null` data:
  13. [source.merge.styled,esql]
  14. ----
  15. include::{esql-specs}/docs.csv-spec[tag=notIsNull]
  16. ----
  17. [%header.monospaced.styled,format=dsv,separator=|]
  18. |===
  19. include::{esql-specs}/docs.csv-spec[tag=notIsNull-result]
  20. |===