Pcount
Aggregation functions pcount
- pcount(a)
- pcount_uint(8|16|32)(a)
- pcount(a) is defined as the uint32 count of the number of entries of a relation in the related domain unit, so pcount(a) is a synonym for count(a, a).
- pcount_uint(8|16|32)(a) is the pcount variant resulting in uint8, uint16 and uint32 data items
Use the has_any function if not the number but the fact that entries do occur is relevant.
- attribute a with uint2, uint4, uint8, uint16, uint32, spoint, ipoint or bool value type
attribute<uint32> pcountReg (Region) := pcount(City/Region_rel);
| City/Region_rel |
|---|
| 0 |
| 1 |
| 2 |
| 1 |
| 3 |
| null |
| 3 |
domain City, nr of rows = 7
| pcountReg |
|---|
| 1 |
| 2 |
| 1 |
| 2 |
| 0 |
domain Region, nr of rows = 5
