Getting '"could not determine data type of parameter $1"

Queries and Resources
1

select jsonb_set(somejsoncolumn::jsonb, ‘{abc, “{{textbox.value}}”}’,’“abc”’, TRUE)) from table
WHERE
carrier_id = 123

but this works in postgress sql. How do i get rid off this error in retool?

2

Hey @gagana – can you try removing the string quotes from around {{ textbox.value }} and see if that works? It should be

sonb_set(somejsoncolumn::jsonb, ‘{abc, {{textbox.value}}}’,’“abc”’, TRUE)) from table
WHERE
carrier_id = 123