# Setup
create or replace table players
  (name VARCHAR, score INTEGER, active BOOLEAN, jerseyNum UINTEGER);

insert into players values (NULL, NULL, NULL, 99);

# Parameterized SQL
prepare update_players as
  -- (name, score, active, jerseyNum)
  UPDATE players
   SET name = $1, score = $2, active = $3
   WHERE jerseyNum = $4
;

execute update_players('Lynx', 10, true, '99');

from players;