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
28041	Postgres prefix searching for full text search	Joe Tsoi	Calvin Vu	"I've needed prefix matching in full text search.  As in #27899, It would be nice to add a `RawSearchQuery`, but also to have it accept a `Lexeme` so your query might look something like

{{{
Dog.objects.annotate(search=SearchVector('name')).filter(search=RawSearchQuery(Lexeme('opt', prefix=True)))
}}}
and combine `Lexeme`s together either ANDing, ORing instead of just letting the user specify the query as a postgres string (https://www.postgresql.org/docs/9.6/static/datatype-textsearch.html#DATATYPE-TSQUERY)
{{{
Dog.objects.annotate(search=SearchVector('name')).filter(search=RawSearchQuery(Lexeme('opt', prefix=True) + Lexeme('blah', invert=True))
}}}"	New feature	closed	contrib.postgres	1.10	Normal	fixed		Calvin Vu	Ready for checkin	1	0	0	0	0	0