How to find output a list of all not found values ​​from an array?

Question

PostgreSQL

Hello. Tell me please. There is a directory, and you need to select those records that are in the array. And also somehow display those values ​​that are in the array, but not in the table.

select * from children where code in 
(select unnest(ARRAY['000000002', '000000012', '000000013','000000014','000000015','000000016','000000017' ]))

Thank you.

Answer 1

select children.code is null as is_not_found, /*another children data is null too*/ 
from unnest(array[...]) as code 
left join children using(code)