1 2 3 | 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