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 getting this 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;
```

what am i doing wrong? thanks!

For plpgsql you need, `BEGIN` and `END` statements.

But you can write this in `sql` as 
```
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 set commands = commands + x;
$$ 
language sql volatile;
```

You might need a `where` clause for the do update, also.

<@!691954098869895178> i updated my code and schema a bit since i realized i needed some more data,

```sql
create function commands_inc (x int, row_id text) 
returns void as
$$
  if (select * from bot_analytics where timestamp > now() - interval '1 week') then
    update bot_analytics set commands = commands + x where bot = row_id
  else
    insert into bot_analytics (commands, bot) values (x, row_id)
  end
$$ 
language plpgsql volatile;
```

right, yeah then it's this issue, 'For plpgsql you need, BEGIN and END statements.'

ah ok so like this?
```sql
create function commands_inc (x int, row_id text) 
returns void as
$$
BEGIN
  if (select * from bot_analytics where timestamp > now() - interval '1 week') then
    update bot_analytics set commands = commands + x where bot = row_id;
  else
    insert into bot_analytics (commands, bot) values (x, row_id);
  end;
END;
$$ 
language plpgsql volatile;
```

or in the if statements?

yes, like that. also to end the if you have to use `end if`