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

Supabase

you need to use the returning clause on your query

This may work depending on situation
```sql
begin
  update profile
  set points = points + 2
  where id::text = new.kid_id
  returning * into new;
  return new;
end;
```

Is this a trigger function?  We last talked in another thread and you were going to use RPC function, which won't have new...

<@!764524500162445402> yes, this time, the new object should have the data I needed. I'm just playing with this function trigger way to learn more about supabase(pgsql)

The RPC way works. I just wondering if I can save a api call from my code to supabase. Normally I can make all calls in my code instead of using functions and rpcs, but for learning purpose and save extra around of the api call 😛