While we can filter and transform arrays using FLATTEN and GROUP BY, it is complicated, and hard to both write and understand. For instance, let's assume t1 is a table, and it has a column named ...
[x] I confirm this is a bug with Supabase, not with my own application. The SQL Editor in the Supabase Dashboard is throwing an incorrect array_agg error when trying ...
I'm brainfarting here... I'm running a query that's just pulling the values that live in one particular column, all numbers. I want to turn all those numbers into a single array. Rows are easy, ...