JSON datatype in postgreSQL
json versus jsonb in PostgreSQL: how each stores its input, why only one of them supports indexing, and how to query both with jsonpath.
Tag
2 pages tagged “Database”.
json versus jsonb in PostgreSQL: how each stores its input, why only one of them supports indexing, and how to query both with jsonpath.
Long queries turn unreadable when the same literal appears five times. Using a WITH common table expression to name constants, scoped to the query and leaving nothing behind.