Search found 8 matches
- Sat Feb 09, 2008 4:31 pm
- Forum: [3.0/Olympus] New features discussion
- Topic: PostgreSQL Fulltext Search
- Replies: 40
- Views: 257818
Re: PostgreSQL Fulltext Search
I added a new version to the first post that should support 8.3.
- Thu Jan 31, 2008 1:49 am
- Forum: [3.0/Olympus] New features discussion
- Topic: PostgreSQL Fulltext Search
- Replies: 40
- Views: 257818
Re: PostgreSQL Fulltext Search
So - Tried a similar search on a forum I know uses this patch ( postgresqlforums.com ) with a search ( "vacuum -thresholds" ) It works on my site. If you query vacuum you get 45 results, and if you query vacuum -thresholds you get 42 results. The one problem with the mod is that it doesn'...
- Tue Nov 20, 2007 1:22 am
- Forum: [3.0/Olympus] New features discussion
- Topic: PostgreSQL Fulltext Search
- Replies: 40
- Views: 257818
Re: PostgreSQL Fulltext Search
my idea regarding the "exact phrase": -- get the search string from the user -- sanitize it by escaping single quotes only -- pass it as is to the search engine through a query, using single quotes. in other words: completely skip the "split keywords" step. this step only makes ...
- Sat Nov 17, 2007 11:41 pm
- Forum: [3.0/Olympus] New features discussion
- Topic: PostgreSQL Fulltext Search
- Replies: 40
- Views: 257818
Re: PostgreSQL Fulltext Search
Sounds good, if you have an ideas for the "exact phrase" search then I think that would be handy as well.
- Fri Nov 16, 2007 12:20 am
- Forum: [3.0/Olympus] New features discussion
- Topic: PostgreSQL Fulltext Search
- Replies: 40
- Views: 257818
Re: PostgreSQL Fulltext Search
* tsearch2 is now fully supported by PhpBB3.x installer, right ? No, this is a customization. * Does your MOD work with PostgreSQL 8.3 beta ? It seems even more easy to use a PostgreSQL beta because tseach2 is integrated. PostgreSQL betas are usually very stable (as strange as it may seem). Only if...
- Tue Aug 21, 2007 11:16 pm
- Forum: [3.0/Olympus] New features discussion
- Topic: PostgreSQL Fulltext Search
- Replies: 40
- Views: 257818
Re: PostgreSQL Fulltext Search
I don't think it will get pulled in for the 3.0 release, as far as I know it is in feature freeze. There are a few things that are less than desirable in the current code, such as I am using function based indexes for to_tsvector (because I hate the idea of adding a column for a tsvector, and then i...
- Tue Aug 07, 2007 2:52 am
- Forum: [3.0/Olympus] New features discussion
- Topic: PostgreSQL Fulltext Search
- Replies: 40
- Views: 257818
Re: PostgreSQL Fulltext Search
Attached is a version for RC4, the author_search method has changed. As for the caching, it would be interesting to see how the caching performs compared against a huge board. Perhaps I should make this an option for fulltext_postgres? I haven't looked at that code too deeply, it is a possibility I ...
- Sun Jul 22, 2007 10:23 pm
- Forum: [3.0/Olympus] New features discussion
- Topic: PostgreSQL Fulltext Search
- Replies: 40
- Views: 257818
PostgreSQL Fulltext Search
I know there has been a few discussions about implementing a fulltext module for PostgreSQL. I guess my first question is has anyone actually done it? I should probably mention that I have done it, and it appears to work. It uses tsearch2, I am interested in what others have done. If you are upgradi...