I'm getting this error when I try to run a query that I've successfully confirms works outside of retool (all parameters in the highlight feature in retool check out as well):
bind message supplies 6 parameters, but prepared statement "" requires 0
DO $$
BEGIN
IF EXISTS (
SELECT * FROM retailer_sku
WHERE retailer_id={{table1.selectedRow.data.id}}
AND sku_id={{input2.value}}
)
then
update retailer_sku
set active=TRUE
WHERE retailer_id={{table1.selectedRow.data.id}}
AND sku_id={{input2.value}}
ELSE
insert into retailer_sku(retailer_id, sku_id, price)
values ({{table1.selectedRow.data.id}}, {{input2.value)}}, 2000);
END IF ;
END
$$ ;