PDO not working, where is the error, 42P08?

Question

PHP

Prepare - "UPDATE public.users SET id=:id, surname=:surname WHERE surname=:surname"
Bind - array(":surname"=>"filipov", ":id"=>18) - tried without : first
Error:
SQLSTATE[42P08]: Ambiguous parameter: 7 ERROR: inconsistent types deduced for parameter $2 LINE 1: UPDATE public.users SET id=$1, surname=$2 WHERE surname=$2 ^ DETAIL: text versus character varying
Data type is correct. ..
But I can’t understand what the error is .. please help

Answer 1

PostgreSQL cannot determine the type of the parameter because it is used twice, in SET and in WHERE. Force its type

UPDATE `public`.`users`
    SET `id` = :id, `surname` = :surname::varchar(20) 
    WHERE `surname` = :surname::varchar(20)