3 ms·
One thing JSONpath does is picking properties from multiple elements of an array, like `$.piff[*].puff` . Postgres jsonb query syntax has no operations on JSONB
by xkcd-sucks 7y ago
One thing JSONpath does is picking properties from multiple elements of an array, like `$.piff[*].puff` . Postgres jsonb query syntax has no operations on JSONB arrays so you have to do some complicated stuff in order to make this query.
Also, the syntax is standardized so people have probably encountered it before in e.g. aws cloudwatch JSON metric filters