studio icon indicating copy to clipboard operation
studio copied to clipboard

PostgreSQL array slice syntax misinterpreted as variable placeholder

Open ouariachi opened this issue 3 months ago • 0 comments

When executing a SQL query containing an array slice expression like:

SELECT a[1:array_length(a,1)-1] FROM (SELECT ARRAY[1,2,3] AS a) t;

Outerbase Studio incorrectly detects the : as the start of a variable placeholder (e.g., :array_length) and prompts the user to input a value.

Expected behavior

The : inside PostgreSQL array slice syntax should be parsed as part of the SQL expression, not as a parameter placeholder.

ouariachi avatar Oct 27 '25 16:10 ouariachi