Project

General

Profile

1 14859 aaronmk
SELECT util.search_path_append('util');
2
3
SELECT create_if_not_exists(
4
$$CREATE INDEX $$||(:table_str||%'__accessRights')||$$
5
ON $$||:table_str||$$ ("accessRights")$$)
6 14860 aaronmk
; -- runtime: 4 s ("3596.509 ms") @frenzy, 3 s ("2533.529 ms") @vegbiendev
7 14859 aaronmk
8
-- remove private data
9
DELETE FROM :table WHERE "accessRights" = 'private'
10
; -- 112 rows (174042 - 173930)