Prev Up Next
sys_stat_histogram Home table_drop_policy

Name

table_set_policy — Sets policy function to table.

Synopsis

table_set_policy ( in tablename varchar ,
in policypl varchar ,
in policy_scope varchar );

Description

Sets policy function to table.

Parameters

tablename

is the table to which the policy applies

policypl

is the actual Virtuoso Stored Procedure based policy

policy_scope

defines the scope of the policy in relation to SQL statement processing using one of more of the following values; I (for Inserts), D (for Deletions), U (for Updates), S (for Selects).

Return Types

varchar

[Note] Note:

Note that the policy_pl procedure should have the following signature (this is how it's called by the Virtuoso SQL compiler to get the policy) :

<procedure_name> (in table varchar, in op varchar) returns varchar
Prev Up Next
sys_stat_histogram Home table_drop_policy