'Postgres DISTINCT Array

I have a PostgreSQL table where there is column which has array of int. The row have some unique array int or some have duplicate strings also

This is my query:

Select DISTINCT(F."Properties") FROM public."Firms" F,
LATERAL UNNEST(F."Properties") AS P
WHERE 
P = ANY(ARRAY[126])
AND F. "RegionId" = 7
AND F. "CityId" = 4365 

Query Result:

enter image description here

I am expecting following output:

2
126
157
783...


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source