How to insert multiselect values as array in PostgreSQL?

Queries and Resources
,
1

My database column value is: character varying(12)[]. I use GUI mode to write Insert or Update SQL queries, but I can't insert multiselect data as SQL array. Maybe, under hood retool generates IN instead of = ANY(...) expression and it leads to invalid SQL query. Or maybe I have misunderstanding about how Retool types work and how does it generate SQL queries. If there is a problem with IN statement, I have to rewrite the SQL query manually?

image
image968×1092 99.9 KB

2

You can turn it into a postgres array formatted string within the GUI interface using curly braces, something like:

{{'{'+selector.value.toString()+'}'}}
so it turns
[1,2,3]
into
"{1,2,3}"
to make it play nicely (and don't forget the quotes enclosing the curly brackets)