Displaying 2 results from an estimated 2 matches for "idxfti".
Did you mean:
identi
2006 Apr 15
0
active record and tsearch2, works?
I have a search form; I grab the value and use it in a fulltext query:
:conditions => ["idxfti @@ ''" + search_string + "''::tsquery and ...........]
Characters in search_string like "?", ":", bomb active record. I tried a
single tick and "\" to escape those, but active record still bombs (same
queries via psql work).
Suggestions?
-T...
2006 Feb 23
0
Searching within active record results - ror n00b
...am trying to be able to narrow searchs and then allow for text searches
using tsearch2 and postgres.
@format = Format.find(@params[:format_id])
@items = @format.items
And then do a find_by_sql on the @items, but I know this isnt how you do
this.
@items.find_by_sql("SELECT * FROM items WHERE idxfti @@
to_tsquery(''default'', ''#{@str}'')
class Format < ActiveRecord::Base
has_and_belongs_to_many :items
belongs_to :parent,
:class_name => "Category",
:foreign_key => "parent_id"
has_ma...