A simple function to increment a number on a postgres database like Supabase

increment_number.sql

drop function increment_views;

create function increment_views(post_slug text)
returns setof public.posts as
$$
  update public.posts
  set views = views + 1
  where slug = post_slug;

  select * from public.posts where slug = post_slug;
$$
language sql volatile;