=?ISO-8859-1?Q?Anders_=D8stergaard_Jensen?= writes:
> Now, let's start out with a classic, non-tsearch2 ILIKE query with two
> wildcards around the search token:
> metabase=# select id, name from customers where name ilike '%holstebr%';
> id | name
> --+---
> 3646 | H
Hello postgresql users,
I have a question regarding building a tsearch2 query that does wildcard
searching by default. Currently, I am using plainto_tsquery(), but it
does not allow me to build more advanced search expressions. I know
to_tsquery is the way to go with this, but I need some qualifie
Hi,
SELECT contentid, title, (rank(to_tsvector(body),q) +
rank(to_tsvector(title),q) + rank(to_tsvector(subtitle),q)) AS Score
FROM content, to_tsquery('parkyeri') AS q
WHERE statusid = 1
AND ispublished = 1
AND (to_tsvector(body) @@ q
OR to_tsvector(title) @@ q
OR to_tsve
