How to get the id of the inserted record?

Question

SQL

How to get the id of the inserted record, not the last one, taking into account multithreading.

Answer 1

The INSERT command returns the id of the new entry.
What exactly is the problem?

Answer 2

PostgreSQL has RETURNING

INSERT INTO ulica (nameulicadop,guid) VALUES
('1 ул','f2ddb1ab-5f51-429a-8a99-84cc9bc124af')
 RETURNING id,guid;