graphile / graphile/graphile.github.io

Add a note about 'NOT NULL' JSONB 'null'

Open
#134 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
SCSS
Stars
27
Forks
126
PR merge metrics
No merged PRs in 30d

Description

```
create table a (
b jsonb not null default 'null'
);
```
We expose this as "non-nullable", but it's possible to store a JSON 'null' (rather than an SQL null) in the column. PostGraphile doesn't differentiate these, and trusts you'll do the right thing. Otherwise _all_ JSON/JSONB columns would have to be nullable, and that'd not be a pleasant experience.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.