Skip to content

Instantly share code, notes, and snippets.

@rectalogic

rectalogic/rx.py

Last active January 12, 2017 16:59
Show Gist options
  • Save rectalogic/7d421c1b7d7f748be6b97c76561e6ae8 to your computer and use it in GitHub Desktop.
Save rectalogic/7d421c1b7d7f748be6b97c76561e6ae8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
rx.py
>>> INDEX_RE = re.compile(r"CREATE( | UNIQUE )INDEX( | CONCURRENTLY)")
>>> INDEX_RE.match("CREATE UNIQUE INDEX CONCURRENTLY foo").group(0)
'CREATE UNIQUE INDEX '
>>> INDEX_RE.match("CREATE UNIQUE INDEX CONCURRENTLY foo").group(1)
' UNIQUE '
>>> INDEX_RE.match("CREATE UNIQUE INDEX CONCURRENTLY foo").group(2)
' '
Raw
rx2.py
>>> INDEX_RE = re.compile(r"CREATE(| UNIQUE) INDEX(| CONCURRENTLY) ")
>>> INDEX_RE.match("CREATE UNIQUE INDEX CONCURRENTLY foo").group(1)
' UNIQUE'
>>> INDEX_RE.match("CREATE UNIQUE INDEX CONCURRENTLY foo").group(2)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment