No-one?

:(

--- In firebird-support@yahoogroups.com, "Tom Conlon" <tomconlon@...>
wrote:

>
> Hi All,
>
> Does anyone have experience of the above and can offer some tips?
>
> Especially with regard to extracting results using bracketed keywords
> and phrases (nothing more fancy is required currently, but I have
> found mapping this query to SQL to be much more challenging than first
> appears):
>
> ("TRAINEE POLICEMAN" OR "TEAM LEADER") AND
> (MONETARY OR INSURANCE AND "PRIVATE BANK")
>
> I've got a certain amount working with one of the key tables
> documented below:
>
> CREATE TABLE DOCUMENTwORD
> (
> DOCID INTEGER NOT NULL,
> WORDID INTEGER NOT NULL,
> WORDNO SMALLINT DEFAULT 0 NOT NULL,
> LINENO SMALLINT DEFAULT 0 NOT NULL,
> );
>
> The wordno column is used in locating phrases.
>
> For the sake of storing the lineno it allows for the
> recreation of a plain text version of the document.
>
> Is FB the best db for this type of task (250,000+ documents). The full
> text features of some other db's didn't quite give me what I was after.
>
> Any thoughts certainly appreciated.
> Tom
>