Issue

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!

Solution

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.