Stored procedure support in Postgresql

[mhalavanja]

Hi, I am sorry if this is already answered somewhere or sth, but I was searching for half an hour and didn't find it.

Is there a way to have custom stored procedures (or functions) with type safe GO code generated?

[mhalavanja]

This is actually what I was looking for https://docs.sqlc.dev/en/stable/howto/named_parameters.html and I will just leave it here if someone will be looking for simmilar question. This works just fine for stored procedures in Postgres:

-- name: TryDeleteGroup :exec
CALL tryDeleteGroup(@group_id::bigint, @user_id::bigint);