Guest User

Untitled

a guest
May 25th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. CREATE TEMPORARY TABLE foo (string text);
  2. INSERT INTO foo VALUES
  3. ('the small but capable man'),
  4. ('the small and strong but capable man');
  5. SELECT * FROM foo WHERE to_tsvector(string) @@ to_tsquery('small<->but');
  6. SELECT * FROM foo WHERE to_tsvector(string) @@ to_tsquery('small<->capable');
  7. SELECT * FROM foo WHERE to_tsvector(string) @@ to_tsquery('small<2>capable');
Add Comment
Please, Sign In to add comment