This Content is from Stack Overflow. Question asked by walle
Simple question from a rookie to PostgREST – is there an intersect function for the equivalent below PSQL query?
select a from table1 intersect select a from table2;
I read through the documentation https://postgrest.org/en/stable/ and didn’t see any commands.
If relevant, I’m using Supabase clients for postgREST right now. Thank you!
You can create a view and then query the view via PostgREST.
This Question was asked in StackOverflow by walle and Answered by thorwebdev It is licensed under the terms of CC BY-SA 2.5. - CC BY-SA 3.0. - CC BY-SA 4.0.