Wow, that would solve one of my current problems on a multitude of levels, especially if this were supported with the odbc_mssql driver as well. I have no idea if mssql even supports the feature though, and especially not if it's something available in mssql2000.
I'm guessing based on the databases that people have available to support that I'm going to kinda be on my own to create a patch for that myself. Something more for Monday, when I'm back at work then. Thanks for the ease-of-use feature, Sharon, I look forward to the added features you're still working on related to this. -Joe On Feb 9, 2008, at 5:48 AM, Sharon Rosner wrote: > > Now that was almost too easy. Full-text search is working in the trunk > for both MySQL and PostgreSQL. Here's how to use it: > > === Creating a full-text index > > DB.create_table :posts do > text :title > text :body > full_text_index [:title, :body] > end > > You can also add an index outside of #create_table: > > DB.add_full_text_index :posts, [:title, :body] > > Or you can supply the full_text option to add_index: > > DB.add_index :posts, :body, :full_text => true > > The PostgreSQL implementation also supports a language setting for the > index: > > DB.add_full_text_index :posts, :body, :language => 'french' > > === Full-text searching > > The new Dataset#full_text_search returns a filtered dataset: > > DB[:posts].full_text_search(:body, 'sequel') > > You can also search on multiple columns: > > DB[:posts].full_text_search([:title, :body], 'sequel') > > Or multiple terms: > > DB[:posts].full_text_search([:title, :body], ['ruby', 'sequel']) > > The MySQL implementation has a boolean mode: > > DB[:posts].full_text_search(:body, '+sequel -activerecord', :boolean > => true) > > The PostgreSQL implementation accepts a language option: > > DB[:posts].full_text_search(:body, 'sequel', :language => 'french) > > And that's about it! Still missing is the ability to order by rank, > and maybe some other stuff, but that will also come soon. > > sharon > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
