Context Navigation

Changes between Initial Version and Version 1 of Ticket #35271, comment 7

initial	v1
3	3	Iterables are valid expressions so I doubt that would be something that would be the correct approach.
4	4
5		If anything, the index should probably coerce basic types list list into their `Value(…)` counterparts as this solves the issue and is something that is done for `db_default` already to solve precisely this issue. To explain: psycopg (3) changed the way lists are rendered as SQL from `ARRAY['foo', 'bar']` to simply `{"foo", "bar"}`. The issue is the ambiguous string which requires casting; and `Value()` expressions are cast.
	5	If anything, the index should probably coerce basic types like list into their `Value(…)` counterparts as this solves the issue and is something that is done for `db_default` already to solve precisely this issue. To explain: psycopg (3) changed the way lists are rendered as SQL from `ARRAY['foo', 'bar']` to simply `{"foo", "bar"}`. The issue is the ambiguous string which requires casting; and `Value()` expressions are cast.