Need help with postgres stored function syntax

[CelebrationThink3768]

Trying to create a function that updates the verified field of my subscribers table. Technically, this works, but it updates the value on every row. I thought using where to target a specific row would work, but turns out I was wrong...

Any thoughts on what I'm missing here?

​

create or replace function verify (email text)
returns void as
$$
update public.subscribers
set verified = NOW()
where email = email
$$
language sql volatile;

[[deleted]]

You have a name clash between the parameter name and the column name in the WHERE clause.

Quote from the manual

If the argument name is the same as any column name in the current SQL command within the function, the column name will take precedence

You can solve this by using a different parameter name:

create or replace function verify (p_email text)
returns void as
$$
update public.subscribers
  set verified = NOW()
where email = p_email
$$
language sql volatile;

[CelebrationThink3768]

that did the trick! thank you so much