]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
add postgresql distinct_on (patch 4)
authorMike Bayer <mike_mp@zzzcomputing.com>
Tue, 25 Feb 2025 15:11:29 +0000 (10:11 -0500)
committerMike Bayer <mike_mp@zzzcomputing.com>
Mon, 17 Mar 2025 19:51:21 +0000 (15:51 -0400)
commit5f8ac7099641a6e78a1bafc00bb82e755c2003ff
tree18e6bd1d31b6c7bbda6bd52482c108e4ef4502b5
parent1d49add43530ecb4011b3fcd057a5273a3be774a
add postgresql distinct_on  (patch 4)

Added syntax extension :func:`_postgresql.distinct_on` to build ``DISTINCT
ON`` clauses. The old api, that passed columns to
:meth:`_sql.Select.distinct`, is now deprecated.

Fixes: #12342
Change-Id: Ia6a7e647a11e57b6ac2f50848778c20dc55eaf54
20 files changed:
doc/build/changelog/unreleased_21/12195.rst
doc/build/changelog/unreleased_21/12342.rst [new file with mode: 0644]
doc/build/dialects/mysql.rst
doc/build/dialects/postgresql.rst
lib/sqlalchemy/dialects/mysql/__init__.py
lib/sqlalchemy/dialects/postgresql/__init__.py
lib/sqlalchemy/dialects/postgresql/base.py
lib/sqlalchemy/dialects/postgresql/ext.py
lib/sqlalchemy/orm/context.py
lib/sqlalchemy/orm/query.py
lib/sqlalchemy/sql/base.py
lib/sqlalchemy/sql/selectable.py
lib/sqlalchemy/testing/fixtures/__init__.py
lib/sqlalchemy/testing/fixtures/sql.py
lib/sqlalchemy/testing/suite/test_select.py
test/dialect/postgresql/test_compiler.py
test/orm/test_core_compilation.py
test/orm/test_query.py
test/sql/test_compiler.py
test/sql/test_text.py