How to form the correct postgres query?

Question

PostgreSQL

Hello! Please help me to form the correct request. If I write like this:

select unnest(nomenclatures),company from nomenclatures_per_company where   'SW 105 050 30 052 SBDH 40 пластина твердосплавная'= ANY (nomenclatures);

then it returns all the positions of the
unnest array to me | company
------------------------------------------------ --+----------
SW 105 045 30 052 SBDH 40 carbide insert | Company Ltd.
SW 105 050 30 052 SBDH 40 carbide insert | Company OOO

But how can I make sure that there is only one position from the filter?
Thanks in advance!

Answer 1

LIMIT?

Answer 2

SELECT DISTINCT ...