How to select Distinct curl query?

unicodes

4 months ago

I'm looking to select from a table all the unique values, is there a way to do it in curl?
Erik Beuschau

4 months ago

What kind of database/interface are you using?
unicodes

4 months ago

Hi Erik, I'm using supabase.
Lucas G

4 months ago

https://docs.postgrest.org/en/v12/references/api/tables_views.html
I believe you can use distinct
Something like GET /table?select=distinct=column_name
🙏1
Would have to test it
unicodes

4 months ago

I tried like this but doesn't work.
Also tried different AI recommendations but nothing :(.
Lucas G

4 months ago

That link has all the filters
I thought I had read distinct on it
unicodes

4 months ago

there is "isdistinct", but I can not understand how to use it. Also read that there is avg, min - max to simulate "distinct" but is not my case, I want to select distinct ids.
Erik Beuschau

4 months ago

Postgrest doesn't support distinct/group by/sub queries as far as I know. Instead you can:
- Reduce the amount of joins you're performing (if that's what gives you duplicate IDs)
- Use a view
unicodes

4 months ago

Thank you Erik, I will try to implement it using functions, or to process the information client side.🙏
Tod

4 months ago

Great energy @unicodes! Your continuous contribution to the toddle Community just made you advance to Community Level 14!