Is it possible to do an UPDATE (SQL) with the output which rows were not found?

Question

PostgreSQL

Hello!
I have a list in table surname and name in excel. Using the concatenate formula, I form the following query:
UPDATE table_name SET surname='surname' WHERE name='name'
There are 6000 rows in the table, 5000 in the base. Is it possible to get a list of which name could not be updated? Well, or just how to make a comparison, but with the output of what is not in the list?

Answer 1

Well, actually load the full list of names into the table (let's say from_excel ) and go

with updated as
( update table_name surname='surname' WHERE name='name'  returning name )
select name from from_excel where name not in ( select name from updated );

Answer 2

You make a temporary table, unload unique identifiers into it, then do an update with the return of UPDATE from bla bla bla RETURNING, which you join with the unloaded data into the temporary.
You can do without a temporary table, but the query will have a lot of nesting.