Why SQL comparisons with NULL do not behave like zero
Understand IS NULL, three-valued logic and the difference between COUNT(*) and COUNT(column).
SQL / PostgreSQL / NULL
TECHNOLOGY / KNOWLEDGE / PRACTICE
Search results: NULL handling
Materials on AI, Python, Git, SQL, SAP/ERP, statistics and time series: explanations, examples, practical tips, sources and applicability limits.
Every word must appear in the article. Use quotes for an exact phrase.
Choose a PostgreSQL foreign-key deletion policy without losing the wrong rows
Compare RESTRICT, CASCADE and SET NULL using a small isolated example, then check the actual constraint and dependent rows before changing real data.
PostgreSQL / SQL / Foreign keys / Transactions