Skip to content

Instantly share code, notes, and snippets.

@rueian
Created January 1, 2020 17:51
Show Gist options
  • Select an option

  • Save rueian/1045ce17a288bcd28af4a46495a2284e to your computer and use it in GitHub Desktop.

Select an option

Save rueian/1045ce17a288bcd28af4a46495a2284e to your computer and use it in GitHub Desktop.
postgres=# select oid, oprname, oprcode, oprrest from pg_operator where oprname = '~~';
 oid | oprname | oprcode | oprrest
 - - - + - - - - -+ - - - - - - + - - - - -
 1207 | ~~ | namelike | likesel
 1209 | ~~ | textlike | likesel
 1211 | ~~ | bpcharlike | likesel
 2016 | ~~ | bytealike | likesel
(4 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment