root/trunk/inputs/Cyrille_traits/trait_observation/postprocess.sql
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) |