Fix restriction on specifying KEEP QUOTES in JSON_QUERY()
Amit Langote <amitlan@postgresql.org>
Fix restriction on specifying KEEP QUOTES in JSON_QUERY() Currently, transformJsonFuncExpr() enforces some restrictions on the combinations of QUOTES and WRAPPER clauses that can be specified in JSON_QUERY(). The intent was to only prevent the useless combination WITH WRAPPER OMIT QUOTES, but the coding prevented KEEP QUOTES too, which is not helpful. Fix that.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/parser/parse_expr.c | modified | +1 −1 |
| src/test/regress/expected/sqljson_jsontable.out | modified | +8 −5 |
| src/test/regress/expected/sqljson_queryfuncs.out | modified | +23 −13 |
| src/test/regress/sql/sqljson_jsontable.sql | modified | +3 −2 |
| src/test/regress/sql/sqljson_queryfuncs.sql | modified | +6 −5 |