Guest User

Untitled

a guest
Jul 27th, 2016
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.16 KB | None | 0 0
  1. with Q as (
  2. select a.*,regexp_split_to_array(txt,' +') arr
  3. from wtest a
  4. )
  5. select * from Q a, Q b
  6. where a.arr <@ b.arr and a.arr @> b.arr and a.id!=b.id
Add Comment
Please, Sign In to add comment