Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

I'm trying to insert into a table from client passing the user_id and getting this error
```js
  message: 'column "user_id" is of type uuid but expression is of type text',
  code: '42804',
  details: null,
  hint: 'You will need to rewrite or cast the expression.'
```

my function
```sql
begin
  INSERT INTO public.payment(user_id)
    VALUES (user_id)
  INSERT INTO public.booking(event_url)
    VALUES (event_url);
    return id;
end;
```

my rpc call
```js
const { data, error } = await supabase.rpc(
 'add_payment',
  {
    user_id: userId,
    event_url: url,
  }
)
```

When you created your function did you define user_id as type uuid?  I also like to name my vars/input parameters different names than the column names just for clarity.

In your booking insert did you mean column user_id to insert event_url into?

you are saying to insert a row into public.booking with the column user_id set to a string event_url(I assume it is a string)

you can't insert event_url (if it is a string) into that column.

event-url is a string and user-id is a uuid

I don't think you understand the insert into syntax then.

the values then go 1 by 1 into the columns you say

so you are creating a new row with user_id column set to event_url which you can't do

im creating a new row in the booking table with a user_id i already have and a new event_url

you probably need something like into (user_id, event_url) values user_id, event_url

you also see why using same names is confusing..

OK you changed it in the original post, is that a change you made to the code, or are you just correcting the post and still have the error?

If you still have the error you should check your actual user_id sent is correct in the post data.

ill have to check my code again and see what i can save from the webhook responses. it'll probably be sometime tomorrow. can i reply here if im having problems or start a new thread?

Should start a new thread, I'm out alot for awhile.