tsearch2 and colons or urls

From: Matthew Terenzio <matt(at)jobsforge(dot)com>
To: PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: tsearch2 and colons or urls
Date: 2005-08-02 02:19:15
Message-ID: 4da45d70cb008659eb170c0b76c176e8@jobsforge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to do a full text search for URL's stored in a table.

SELECT *,headline(description,q), rank(vectors,q) FROM bb_item,
to_tsquery('http://www.yahoo.com') AS q WHERE vectors @@ q ORDER BY
rank(vectors,q) DESC LIMIT 10 OFFSET 0

I get a general syntax error. I know it;s the colon in the URL causing
it, but what is the wise solution. ( Other than drop the http:// )

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2005-08-02 02:24:00 Re: SELECT count(*) Generating Lots of Write Activity
Previous Message Tom Lane 2005-08-02 02:08:37 Re: SELECT count(*) Generating Lots of Write Activity