Pcount
aggregation-functions pcount
syntax
- pcount(a)
-
pcount_uint(8 16 32)(a)
definition
- 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
description
Use the has_any function if not the number but the fact that entries do occur is relevant.
applies to
- attribute a with uint2, uint4, uint8, uint16, uint32, spoint, ipoint or bool value-type
example
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