Hello! I use PostgreSQL, and this is how I accomplished a full text search:
def search(request): # how to set up postgresql for full text searching #alter table quote_quote add column body_tsv tsvector; #CREATE TRIGGER quote_quote_tsvectorupdate BEFORE INSERT OR UPDATE ON quote_quote FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger(quote_tsv, 'pg_catalog.english', quote); #CREATE INDEX quote_quote_tsv ON quote_quote USING gin(quote_tsv); #UPDATE quote_quote SET quote_tsv=to_tsvector(quote); q = request.GET['q'] quotes = Quote.objects.extra( select={ 'snippet': "ts_headline(quote, plainto_tsquery(%s))", 'rank': "ts_rank_cd(quote_tsv, plainto_tsquery(%s), 32)", }, where=["quote_tsv @@ plainto_tsquery(%s)"], params=[q], select_params=[q, q], order_by=('-rank',) ) paginator = Paginator(quotes, 50) try: page = int(request.GET.get('page', '1')) except ValueError: page = 1 try: quotes = paginator.page(page) except (EmptyPage, InvalidPage): quotes = paginator.page(paginator.num_pages) my_data_dictionary = { 'quotes': quotes, 'q' : q, } return render_to_response('results.html', my_data_dictionary, context_instance=RequestContext(request)) urlpatterns = patterns('', url(r'^search/$', search), ) On Fri, Oct 1, 2010 at 7:26 PM, Andrej <amas...@gmail.com> wrote: > Check this out: > > http://www.julienphalip.com/blog/2008/08/16/adding-search-django-site-snap/ > > On Oct 1, 6:52 am, Alessandro Ronchi <alessandro.ron...@soasi.com> > wrote: >> On Fri, Oct 1, 2010 at 3:35 AM, Steve Holden <holden...@gmail.com> wrote: >> > On 9/30/2010 8:26 PM, Nick Arnett wrote: >> > > Brain is mush, though. >> >> Thank you. I'm waiting with hope :) >> >> -- >> Alessandro Ronchihttp://www.soasi.com > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-us...@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.