I just wanted to add my solution to update several entries with one query. I tried to build a minimal example. Hopefully this helps someone in the future!
My workaround is to build PostgreSQL value lists from the input data table and concatenate them to a combined values list. The trick is to add “::interval” to the future interval column there and not in the SQL query (took me a while to find this solution). For more details, check the workflow below!
Best,
Johann
PSQL_type_interval.knwf (13.2 KB)