Re: Free format text searches ?

In article <01bbc787$263090d0$a0567ec2@workstation>, Steven Wort <SWort@globalnet.co.uk> wrote: >Can anyone tell me how to do free format text searches across multiple >columns and tables. > >What I am looking for is the ability to automatically generate a keyword >index on textual data as it is entered to the DB, so that subsequent >searches to are very fast? > I did something like this some time ago with a separate table (e.g. keywords), that would hold all the words from other columns in other tables. Use one or more rules on insert, delete and update on the columns, where you want to extract the keywords. Keep some information about where you would find your keyword in your original data. As far as I understand, it is not exactly what you want, but it will work very well and similar to the way you want it. Oh well - I assume, you are using OpenIngres (or Ingres). It is not quite obvious what DBMS System you are using... Thomas Mack TU Braunschweig, Abt. Datenbanken