select position('test' in rule_name) from logs limit 5;
vysledek
0
5
5
4
1
(5 rows)
select sum(position('test' in rule_name)) from logs limit 5;
ma byt vysledkem 5+5+4+1 tj. 15 nebo ma byt stejny jako v prikazu:
select sum(position('test' in rule_name)) from logs;