(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