support postgres json_object syntax
#1545
Comments
lovasoa
added a commit
to lovasoa/sqlparser-rs
that referenced
this issue
Nov 24, 2024
This just updates the postgres dialect definition to add support for the json_object syntax added in apache#1507 The syntax was initially added for mssql but also works in postgres See https://www.postgresql.org/docs/current/functions-json.html See apache#1545
lovasoa
added a commit
to lovasoa/sqlparser-rs
that referenced
this issue
Nov 24, 2024
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Postgresql supports the following syntax for the json_object function:
Reference: https://www.postgresql.org/docs/current/functions-json.html
Related: the
key: valuesyntax was already implemented for mssql by @gaoqiangz in #1507 . We probably just need to enable it (+ a new VALUE separator) for postgres too#1506
Initially reported in sqlpage/SQLPage#708
The text was updated successfully, but these errors were encountered: