tsearch2 and colons or urls

[Matthew Terenzio <matt@xxxxxxxxxxxxx>]

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:// )


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq