Yep. This assumes you've set up foreign key relationships for team1 and team2.

i did set up

but the relationship is between the matches table and the teams table

Sorry, I didn't study your schema closely enough. Those should be inside the "matches" parentheses.

no worries

i did this, and it is throwing me an error

Is it the extra comma?

oh, it might be

let me sese

it was

thank you very much sir

Cool. What does

single()

do? Return one row?

it returns a single object instead of returning an array with one object only

with single

TIL... That's nice. Didn't know that.

hehe

I'd buy you a beer if i could

thank you very much, again

You're welcome. Someone else helped me with that one when I came across it. :-)

I'll be on the lookout to help the next one

👍

Hello, I would like to know if it's possible to add CORS rule policy to access a database only from a specific client ? If it's possible, can someone link me to the documentation, would really appreciate it ! thank you

There's a thread on this message which has a discussion about it: https://discord.com/channels/839993398554656828/839993398554656831/871166066871636024 - There's also a different thread with more details: #871172819201953822

yes, that's it. thanks!

hi - I am trying to create a trigger on my auth.users like this: https://github.com/supabase/supabase/issues/563#issuecomment-772954907 to update my public.users when a new user signs up but I get

server_error&error_description=Database+error+saving+new+user

returned when trying to sign up via Oauth on the client. Anyone have a clue?

Hi! Can i use Prisma and Supabase Realtime APIs together?, im trying to make a query using Supabase API on a DB generated with Prisma, but i get this error: message: 'permission denied for schema public', I turn on all my tables, and im using service_role KEY, to bypass RLS, many thanks!

thank you !

I had a similar issue and I saw a workaround which said to change the name of public.users to something else (I.E. accounts). I tried it whilst implementing this https://github.com/supabase/supabase/issues/563#issuecomment-772954907 (obviously swapping public.users to public.accounts) and it worked for me.