[FORMATTING] Can't handle array type

[Mooli88]

Input data

Which SQL and options did you provide as input?

CREATE TABLE public.todos (
  assigned_to UUID[] NOT NULL
);

Expected Output No change or:

assigned_to UUID [] NOT NULL

Actual Output

Error: Unable to format SQL: Error: Parse error: Unexpected "[] NOT NUL" at line 27 column 21

Usage

• How are you calling / using the library? - Vscode format document / Shift + Option + F
• What SQL language(s) does this apply to? - Postgres
• Which SQL Formatter version are you using? - v1.6.0

[nene]

Please read the FAQ that you can find in the README. Your problem is solved by correct configuration and by not using the outdated VSCode plugin.

On Sat, Sep 7, 2024, 02:24 Mooli @.***> wrote:

Input data

Which SQL and options did you provide as input?

CREATE TABLE public.todos ( assigned_to UUID[] NOT NULL );

Expected Output No change or:

assigned_to UUID [] NOT NULL

Actual Output

Error: Unable to format SQL: Error: Parse error: Unexpected "[] NOT NUL" at line 27 column 21

Usage

• How are you calling / using the library? - Vscode format document / Shift + Option + F
• What SQL language(s) does this apply to? - Postgres
• Which SQL Formatter version are you using? - v1.6.0

— Reply to this email directly, view it on GitHub https://github.com/sql-formatter-org/sql-formatter/issues/777, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAA43OOEV6SBOPGZQAS424LZVI2SBAVCNFSM6AAAAABNZOBTKKVHI2DSMVQWIX3LMV43ASLTON2WKOZSGUYTCMZRGA4DENY . You are receiving this because you are subscribed to this thread.Message ID: @.> [ { @.": "http://schema.org", @.": "EmailMessage", "potentialAction": { @.": "ViewAction", "target": " https://github.com/sql-formatter-org/sql-formatter/issues/777", "url": " https://github.com/sql-formatter-org/sql-formatter/issues/777", "name": "View Issue" }, "description": "View this Issue on GitHub", "publisher": { @.***": "Organization", "name": "GitHub", "url": "https://github.com" } } ]