CREATE TABLE IF NOT EXISTS public.users ( id bigserial NOT NULL, phone text , created_at timestamp with time zone, updated_at timestamp with time zone, CONSTRAINT users_pkey PRIMARY KEY (id) ) CREATE OR REPLACE FUNCTION public.fn_authrepo_create_user( var_phone text, var_created_at timestamp with time zone, var_updated_at timestamp with time zone) RETURNS TABLE(user_id BIGINT, created_at timestamp with time zone, updated_at timestamp with time zone) LANGUAGE 'plpgsql' COST 100 VOLATILE PARALLEL UNSAFE AS $BODY$ DECLARE v_user_id BIGINT; v_created_at TIMESTAMPTZ; v_updated_at TIMESTAMPTZ; BEGIN INSERT INTO users (phone, created_at, updated_at) VALUES (var_phone, var_created_at, var_updated_at) RETURNING users.id, users.created_at, users.updated_at INTO v_user_id, v_created_at, v_updated_at; RETURN QUERY SELECT v_user_id, v_created_at, v_updated_at; END; $BODY$;

-- name: CreateUser :one SELECT * FROM fn_authrepo_create_user($1, $2, $3);