#3254: [patch] experimental fulltext search support for postgres, oracle and
mssql
---------------------------------------------------+------------------------
Reporter: Ronny Pfannschmidt | Owner: nobody
Status: new | Milestone:
Component: Database layer (models, ORM) | Version:
Resolution: | Keywords: oracle
fulltext search
Stage: Accepted | Has_patch: 1
Needs_docs: 1 | Needs_tests: 1
Needs_better_patch: 1 |
---------------------------------------------------+------------------------
Old description:
> 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 description:
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
Comment (by ramiro):
(description)
--
Ticket URL: <http://code.djangoproject.com/ticket/3254#comment:19>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
