Steven Liu
ย ยทย FF Expert & Ambassador | Helping you launch your app - hundredacretech.com | youtube.com/@StevenNoCode

Supabase 'array_agg' function wrong order

Hey all,

Has anyone experienced where supabase's array_agg function is returning the wrong order in the array?

For example, the first screenshot is non-aggregated and we can see here a nickname for each corresponding user_id.

However in the second screenshot when I tried to aggregate them into an array, the order is not correct (i.e. James has user_id of 3ce... which belongs to Steven based off the first screenshot).

1
2 replies