pgsql-ast-parser
pgsql-ast-parser copied to clipboard
Missing another POSIX regex match operator: !~
This library looks fantastic - looking at using it in a Deno project I'm currently working on.
One of my first queries failed though - simplified version is:
SELECT nspname FROM pg_catalog.pg_namespace WHERE nspname !~ '^pg_temp_'
Fails with:
error: Uncaught Error: invalid syntax at line 1 col 60:
SELECT nspname FROM pg_catalog.pg_namespace WHERE nspname !~ '^pg_temp_'
^
Unexpected input (lexer error). Instead, I was expecting to see one of the following:
- A "dot" token
- A "dot" token
- A "lparen" token
- A "dot" token
- A "op_cast" token
- A "lbracket" token
- A "op_member" token
- A "op_membertext" token
- A "kw_array" token
- A "lbracket" token
- A "string" token
- A "eString" token
- A "word" token
- A "word" token
- A "op_exp" token
- A "star" token
- A "op_div" token
- A "op_mod" token
- A "op_plus" token
- A "op_minus" token
- A "op_additive" token
- A "kw_not" token
- A "kw_in" token
- A "kw_not" token
- A "op_like" token
- A "op_ilike" token
- A "op_not_like" token
- A "op_not_ilike" token
- A "kw_like" token
- A "kw_ilike" token
- A "ops_others" token
- A "kw_not" token
- A "kw_is" token
- A "kw_notnull" token
- A "kw_is" token
- A "kw_isnull" token
- A "kw_is" token
- A "word" token
- A "op_compare" token
- A "op_eq" token
- A "op_neq" token
- A "kw_and" token
- A "kw_or" token
- A "kw_group" token
- A "kw_order" token
- A "kw_for" token
- A "kw_offset" token
- A "kw_limit" token
- A "kw_fetch" token
- A "kw_union" token
- A "semicolon" token
Using version 10.5.2
Easy to fix? Similar to #28 ?
Thanks, - John