select x.y, to_tsvector('english',x.y) @@ to_tsquery('english','quic:*') as match from (values ('The quick brown fox jumps over the lazy dog')) as x(y)
Output:
y | match ---------------------------------------------+------- The quick brown fox jumps over the lazy dog | t (1 row)
Thank you. Needed that :* part. :)
ReplyDeleteThanks, very useful.
ReplyDelete