PSQL Missing Highlight Syntax after Array expression

Question

I have noticed that the highlight missing after the ARRAY expression [ ]. The PSQL script can be run successfully but it's quite annoying.

SELECT ARRAY [ CONCAT('0', SUBSTRING(REGEXP_REPLACE(test.elec_num, '[^0-9]', '', 'g') FROM 3)) ] 
FROM test 
WHERE LENGTH(test.elec_num) > 10;

Is there any way to fix this issue?

Timothy G. · Accepted Answer · 2021-07-02 12:35:52Z

1

I think the issue is that the SQL language support that comes out of the box with Visual Studio Code is configured for T-SQL, instead of PL/pgSQL like Postgres implements. It looks like the single quotes are throwing the syntax highlighting off in your case.

I found a Postgres Extension, called PostgreSQL that after installing, the syntax of your SQL above looks more appropriate (note, this is also after changing the language to postgres, which is added by this extension):

edited Jul 2, 2021 at 12:35

answered Jul 2, 2021 at 12:30

Timothy G.

9,8597 gold badges50 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TK45 Over a year ago

Installed! Thank you, that makes sense since VS Code's Microsoft product. (That's why default SQL should set as T-SQL)

Collectives™ on Stack Overflow

PSQL Missing Highlight Syntax after Array expression

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related