Advertisement
Guest User

Untitled

a guest
Jul 26th, 2016
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. with alias_search as (
  2.     SELECT
  3.     array_to_string(aliases, ',') as string_array,
  4.     id,
  5.     name,
  6.     opeid,
  7.     city,
  8.     state
  9.     FROM universities
  10. )
  11. SELECT
  12.  id,
  13.  name,
  14.  opeid,
  15.  city,
  16.  state
  17. from alias_search
  18. WHERE string_array ~* ?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement