Supabase•4y ago•

7 replies

Help creating policy based on incoming data

I have a

friend_requests

friend_requests

table and I want to make sure that there can never be duplicate requests.

friend_requests

friend_requests

has 3 columns that are

sender_id

sender_id

receiver_id

receiver_id

, and

created_at

created_at

I have a function that I'm creating which is called

friend_request_exists

friend_request_exists

and takes in an argument of

receiver_id

receiver_id

The problem is when I create my policy for

INSERT

INSERT

, I'm not sure how to grab that

receiver_id

receiver_id

to run this function.

I've attached some screenshots for the function I created and how I'm trying to setup my

INSERT

INSERT

policy.

Thank you in advance.