Opened 18 years ago

Last modified 19 months ago

#3254 new New feature

[patch] experimental fts support for postgres, oracle and mssql — at Initial Version

Reported by: Ronny Pfannschmidt <ronny.pfannschmidt@…> Owned by: nobody
Component: Database layer (models, ORM) Version:
Severity: Normal Keywords: oracle fulltext search postgresql postgres mysql
Cc: sam@…, johann.queuniet@…, hv@…, rboumart@…, dan.fairs@…, twidi@…, Matt Boersma, justinlilly@…, James Pic, robinchew@…, niwi@…, slav0nic@…, mpessas@…, tomi.kyostila@…, Matt Goldman Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

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

Change History (1)

by Ronny Pfannschmidt <ronny.pfannschmidt@…>, 18 years ago

Note: See TracTickets for help on using tickets.
Back to Top