SELECT t.fld1, t.fld2 IS NULL, MAX(t.fld3) FROM my_table t GROUP BY t.fld1, t.fld2 IS NULL INTO :var_fld1, :var_fld2, :var_fld3;
NEW.fld_bool = NULLIF(NEW.fld_val IS NOT NULL, FALSE);
