pgsql-ast-parser icon indicating copy to clipboard operation
pgsql-ast-parser copied to clipboard

Missing another POSIX regex match operator: !~

Open johnspurlock opened this issue 3 years ago • 0 comments

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

johnspurlock avatar Jul 04 '22 19:07 johnspurlock