]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
JSONPATH type can be used in casts in PostgreSQL
authorFederico Caselli <cfederico87@gmail.com>
Tue, 2 Aug 2022 10:27:57 +0000 (12:27 +0200)
committerMike Bayer <mike_mp@zzzcomputing.com>
Wed, 17 Aug 2022 15:50:24 +0000 (11:50 -0400)
commit2e7117ab1b584e678380c70625ad1331cea551d0
tree8defd69fd3202159842511dfc4e9d22e21ad9e7a
parenta134ec1760df6295d537ff63df7aee83d957bf6a
JSONPATH type can be used in casts in PostgreSQL

Introduced the type :class:`_postgresql.JSONPATH` that can be used
in cast expressions. This is required by some PostgreSQL dialects
when using functions such as ``jsonb_path_exists`` or
``jsonb_path_match`` that accept a ``jsonpath`` as input.

Fixes: #8216
Change-Id: I3e7337eab91680cab1604e1f3058854a0a19c5be
doc/build/changelog/unreleased_20/8216.rst [new file with mode: 0644]
doc/build/dialects/postgresql.rst
lib/sqlalchemy/dialects/postgresql/__init__.py
lib/sqlalchemy/dialects/postgresql/asyncpg.py
lib/sqlalchemy/dialects/postgresql/base.py
lib/sqlalchemy/dialects/postgresql/json.py
lib/sqlalchemy/sql/sqltypes.py
test/dialect/postgresql/test_compiler.py
test/dialect/postgresql/test_types.py