chango.git/tests/postgres_tests/fields.py, branch devmain

Fixed #36727 -- Deprecated Field.get_placeholder in favor of get_placeholder_sql.

2026-03-13T00:01:02Z

The lack of ability of the get_placeholder call chain to return SQL and parameters separated so they can be mogrified by the backend at execution time forced implementations to dangerously interpolate potentially user controlled values. The get_placeholder_sql name was chosen due to its proximity to the previous method, but other options such as Field.as_sql were considered but ultimately rejected due to its different input signature compared to Expression.as_sql that might have lead to confusion. There is a lot of overlap between what Field.get_db_prep_value and get_placeholder_sql do but folding the latter in the former would require changing its return signature to return expression which is a way more invasive change than what is proposed here. Given we always call get_db_prep_value it might still be an avenue worth exploring in the future to offer a publicly documented interface to allow field to take an active part in the compilation chain. Thanks Jacob for the review.

Fixed #36748 -- Filtered non-standard placeholders from UNNEST queries.

2025-11-20T22:22:46Z

Applied Black's 2024 stable style.

2024-01-26T11:45:07Z

https://github.com/psf/black/releases/tag/24.1.0

Refs #33872 -- Removed django.contrib.postgres.fields.CIText/CICharField/CIEmailField/CITextField.

2023-09-18T20:12:40Z

Per deprecation timeline.

Fixed #33872 -- Deprecated django.contrib.postgres.fields.CIText/CICharField/CIEmailField/CITextField.

2022-08-03T09:42:51Z

Refs #33476 -- Reformatted code with Black.

2022-02-07T19:37:05Z

Fixed #27147 -- Allowed specifying bounds of tuple inputs for non-discrete range fields.

2021-11-04T18:08:57Z

Fixed #26167 -- Added support for functional indexes.

2021-01-13T10:47:50Z

Thanks Simon Charette, Mads Jensen, and Mariusz Felisiak for reviews. Co-authored-by: Markus Holtermann

Fixed #12990, Refs #27694 -- Added JSONField model field.

2020-05-08T05:23:31Z

Thanks to Adam Johnson, Carlton Gibson, Mariusz Felisiak, and Raphael Michel for mentoring this Google Summer of Code 2019 project and everyone else who helped with the patch. Special thanks to Mads Jensen, Nick Pope, and Simon Charette for extensive reviews. Co-authored-by: Mariusz Felisiak

Fixed #29391 -- Made PostgresSimpleLookup respect Field.get_db_prep_value().

2019-02-09T23:05:50Z