How can I add a variable in this ``` select jsonb path query Supabase #sql

How can I add a variable in this? ``` select jsonb...

jar

07/10/2022, 5:09 AM

How can I add a variable in this?

Copy code

select jsonb_path_query_array('[1,2,7,4,5]'::jsonb, ('$[0 to 2]'));

works

Copy code

select jsonb_path_query_array('[1,2,7,4,5]'::jsonb, ('$[0 to '||2||']'));

doesnt work