id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
27694	Improve documentation of supported lookups on HStore & JSON fields	Stephen Burrows	Sarah Abderemane	"[https://docs.djangoproject.com/en/dev/ref/contrib/postgres/fields/ The documentation of supported lookups on HStore & JSON fields is lacking.] For example, HStoreField supports `iexact` lookups, but the documentation has a scary warning implying that this is not the case:

    Since any string could be a key in a hstore value, any lookup other than those listed below will be interpreted as a key lookup.

iexact is not listed below – but neither is contains, which is used directly ''above'' the scary warning as an example of how ""You can chain other lookups after key lookups"". (Actually, contains ''is'' listed below, but it's a different contains that applies only to the field level and not to a specific key.)

I suspect that the intended meaning is that ''all'' lookups are supported after a key lookup, and that the ''first'' lookup on the hstore field must be a key or one of the special lookups listed below.

JSONField does not mention being able to chain lookups after key lookups at all - but I can see people using gt and in [http://www.lexev.org/en/2015/trying-json-combo-django-and-postgresql/ in blog posts like this]. BUT iexact lookups [https://code.djangoproject.com/ticket/27693 don't currently work] on JSONField.
"	Cleanup/optimization	closed	Documentation	dev	Normal	fixed			Accepted	1	0	0	0	1	0