(a)
create table t_profile_column_values
(id int not null,
test int NULL,
parent1 int NULL,
parent2 int NULL,
c_name varchar(30) not null,
operator char(2) not null, /* '==' or '!=' */
c_value varchar(255) not null
)
(b)
SELECT P.ProfileID, M.TargetValue, count(*)
FROM t_mine_relations M, profiles P
WHERE {profile P matches M}
GROUP BY P.ProfileID, M.TargetValue
Example 1: (a) SQL WHERE clause represented as a profile; (b) potential WHERE clauses within the current GP generation can be evaluated with a single SQL statement.
Back to Article