How to complete this sql statement?

[renjunok]

Database schema

create table users
(
    name      uuid                                   not null,
   emails     varchar()[]                         not null
);

SQL queries

-- name: AddEmail :exec
UPDATE users
SET emails = $1 || emails
WHERE name = $2;

update users SET emails = '{abc@test.com}' || emails where name = 'john'

The generated code now

type AddEmailsParams struct {
	emails []string 
	Code   string 
}

Does every update need to read all the data in the email field in advance?
Is there a better solution, thanks!

[renjunok]

-- name: AddEmail :exec
UPDATE users
SET emails = $1::varchar() || emails
WHERE name = $2;

should be written like this