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

Supabase

what's wrong with my function that i'm trying to make?
keeps saying "syntax error at or near "if""
```sql
create function commands_inc (x int, row_id text) 
returns void as
$$
  if exists (select 1 from bot_analytics where id = row_id) then
  begin
    update bot_analytics 
    set commands = commands + x
    where id = row_id
    end
  else
  begin
    insert into bot_analytics (id, commands)
    values (row_id, x)
  end if
$$ 
language plpgsql volatile;
```

Hello <@401792058970603539>!
This thread has been automatically created from your message in <#843999948717555735> a ``few seconds ago``.

Pinging <@&951828363943759883> so that they see this as well!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ... menu) and select **Leave Thread** to unsubscribe from future updates.

**Want to change the title?**
Use the `/title` command!

**We have solved your problem?**
Click the button below to archive it.

I think you can write this as a `insert ... on conflict ... do update` statement 🙂

still get a similar error, `syntax error at or near "insert"`

```sql
create function commands_inc (x int, row_id text) 
returns void as
$$
  insert into command_logs (id, commands) values (row_id, x) on conflict do update
$$ 
language plpgsql volatile;
```

actually i'll repost this in <#869405720934744086> as its more relevant