Skip to content
Katabench
Try free

Absent, Null, or Empty?

Easy About 12 min Katabench Pro

Distinguish a missing JSON key, explicit JSON null, an empty string, and every other value before grouping the audit.

The full brief is part of Katabench Pro

Pro opens this kata's brief, its starter code and its grader. To see how the track works first, try Existence Without Loading, which is free.

How it is graded

Your LINQ or SQL runs against real PostgreSQL. You see the SQL your code generates on the sample tests and can inspect its execution plan, so you learn when the database did the wrong work.

EF Core practice →

What it practices

JSON and arrays in PostgreSQL
Query jsonb documents and array columns with typed extraction, containment and expansion.
NULL semantics
Three-valued logic, NULL-aware comparisons, and how NULL changes counts and averages.

Related katas