diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-08 08:11:53 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-08 08:12:02 +0000 |
| commit | 8d36f5966675e23bee7026ba37ae0647fbf47300 (patch) | |
| tree | df4227bbb3b07cb70df87237bcff03c8efd7822d /sqlglot/dialects/postgres.py | |
| parent | Releasing debian version 22.2.0-1. (diff) | |
| download | sqlglot-8d36f5966675e23bee7026ba37ae0647fbf47300.tar.xz sqlglot-8d36f5966675e23bee7026ba37ae0647fbf47300.zip | |
Merging upstream version 23.7.0.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'sqlglot/dialects/postgres.py')
| -rw-r--r-- | sqlglot/dialects/postgres.py | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sqlglot/dialects/postgres.py b/sqlglot/dialects/postgres.py index b53ae07..11398ed 100644 --- a/sqlglot/dialects/postgres.py +++ b/sqlglot/dialects/postgres.py @@ -278,6 +278,7 @@ class Postgres(Dialect): "REVOKE": TokenType.COMMAND, "SERIAL": TokenType.SERIAL, "SMALLSERIAL": TokenType.SMALLSERIAL, + "NAME": TokenType.NAME, "TEMP": TokenType.TEMPORARY, "CSTRING": TokenType.PSEUDO_TYPE, "OID": TokenType.OBJECT_IDENTIFIER, @@ -356,6 +357,16 @@ class Postgres(Dialect): JSON_ARROWS_REQUIRE_JSON_TYPE = True + COLUMN_OPERATORS = { + **parser.Parser.COLUMN_OPERATORS, + TokenType.ARROW: lambda self, this, path: build_json_extract_path( + exp.JSONExtract, arrow_req_json_type=self.JSON_ARROWS_REQUIRE_JSON_TYPE + )([this, path]), + TokenType.DARROW: lambda self, this, path: build_json_extract_path( + exp.JSONExtractScalar, arrow_req_json_type=self.JSON_ARROWS_REQUIRE_JSON_TYPE + )([this, path]), + } + def _parse_operator(self, this: t.Optional[exp.Expression]) -> t.Optional[exp.Expression]: while True: if not self._match(TokenType.L_PAREN): @@ -484,6 +495,7 @@ class Postgres(Dialect): ] ), exp.StrPosition: str_position_sql, + exp.StrToDate: lambda self, e: self.func("TO_DATE", e.this, self.format_time(e)), exp.StrToTime: lambda self, e: self.func("TO_TIMESTAMP", e.this, self.format_time(e)), exp.StructExtract: struct_extract_sql, exp.Substring: _substring_sql, |