graphile / graphile/graphile.github.io
Add a note about 'NOT NULL' JSONB 'null'
Open
- 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.