Top

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