'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:
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 |
---|