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
3254	full text search support for postgres, oracle and mssql	Ronny Pfannschmidt	Akash Kumar Sen	"I didn't like it was missing.

oracle, mssql : add a !FulltextIndex for the Fields

postgresql: for each !FulltextField add a extra tsvector Field named like `""%(fieldname)_tsv""`

Problems with sqlite fts:

 * they stated a match statement may only be used once in a query
 * it needs a very specific syntax to search multiple fields
 * i have no idea how to get that into the ORM
"	New feature	assigned	Database layer (models, ORM)		Normal		oracle fulltext search postgresql postgres mysql	sam@… johann.queuniet@… hv@… rboumart@… dan.fairs@… twidi@… Matt Boersma justinlilly@… James Pic robinchew@… niwi@… slav0nic@… mpessas@… tomi.kyostila@… Matt Goldman Alexander Nestorov	Accepted	0	0	0	0	0	0