In cases where the field is required I would agree. But in the context of an upd... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

CipherThrowaway on July 11, 2022 | parent | context | favorite | on: Postgres 15 improves UNIQUE and NULL

In cases where the field is required I would agree. But in the context of an update request, {"foo":null} and {} might both be valid with different semantics. "Update this field to null" vs "don't update this field"

dbrgn on July 11, 2022 [–]

A similar issue is {}, {"mylist": null} and {"mylist": []}. Three ways to represent a missing or empty list.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact