Skip to content

PostgreSQL ^@ ANY operator causes parse error #79

@nene

Description

@nene

The following fails to parse:

SELECT 'foo' ^@ ANY = '{f,b}'
Syntax Error: Unexpected "ANY"
Was expecting to see: "$", "(", "+", "-", ":", "?", "@", "ARRAY", "CASE", "CAST", "CURRENT_CATALOG", "CURRENT_DATE", "CURRENT_DATETIME", "CURRENT_ROLE", "CURRENT_SCHEMA", "CURRENT_TIME", "CURRENT_TIMESTAMP", "CURRENT_USER", "DATE", "DATETIME", "EXISTS", "EXTRACT", "FALSE", "INTERVAL", "JSON", "JSONB", "LOCALTIME", "LOCALTIMESTAMP", "NULL", "OPERATOR", "ROW", "SAFE_CAST", "SESSION_USER", "SYSTEM_USER", "TIME", "TIMESTAMP", "TRUE", "USER", "X", "b", "~", identifier, number, string, or whitespace
--> undefined:2:17
  |
2 | SELECT 'foo' ^@ ANY = '{f,b}'
  |                 ^

See also: sql-formatter-org/sql-formatter#734

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions