>> 1) Temporary tables
>since 2.1 - see release notes for 2.1

Excellent. I'll dig in there.

>select blobfield from table where blobfield containing 'my search string';
>will always return records whre the blob contains 'my search string'

Yeah, by full text search I mean tokenized lexeme search within fields that wouldn't require a table scan.

>Several third party products add to this - refer to ibphoenix.com website
>for more info and links

I haven't found any cross-platform solutions that work on Mac and Windows. It looks like the sphinx library patch comes closest, since it works on Linux, but it looks like it'd require some tweaking to bring it up on the Mac with firebird (maybe not too much, not sure). There doesn't seem to be a ready-to-go solution on the Mac. Someone correct me if I'm mistaken.

>firefox is the browser

Oopsie. Freudian slip.

Thanks for the suggestions!

-Paul



________________________________
From: Alan McDonald <alan@...>
To: firebird-support@yahoogroups.com
Sent: Wednesday, May 6, 2009 1:43:44 PM
Subject: RE: [firebird-support] Two FAQ's

> Hi there,
>
> So I wanted to ask these, since I've gotten conflicting information
> about them. I was wondering if firebird supports the following in
> either the current version or in the upcoming 2.5:
>
> 1) Temporary tables

since 2.1 - see release notes for 2.1

> 2) Full text search / indexing

select blobfield from table where blobfield containing 'my search string';
will always return records whre the blob contains 'my search string'
in this case, the blobs must be plain text. records which contain e.g. 'my
<b>search</b> string' will not be returned.
indexing is limited by an index key length limit and blob field indexing is
not possible.
Several third party products add to this - refer to ibphoenix.com website
for more info and links

>
> We would love to use firefox for our project, but need these two to
> make it work.

firefox is the browser. we forced them to change their proposed name.
Alan

>
> Thanks!
>
> -Paul

[Non-text portions of this message have been removed]