i have a record set like below:
num_prods|num_open_issues|num_provisioned|num_canceled
1|0|1|0
2|0|0|2
3|0|1|1
2|0|1|1
1|0|01
2|0|0|0
3|3|0|0
3|0|0|3
3|1|0|2
3|2|0|1
2|0|2|0
Of the list above only row 3 and row 6 should be returned.
Plain english definition:
With a result set like above eliminate all rows that should not show
up on the provision List. Provision List Definition: All rows that
have products that need provisioning. Provisioning means its NOT
canceled and it does NOT have an open issue. Some facts:
num_open_issues + num_provisioned + num_canceled will never be more
than num_prods.
no individual column will ever be more than num_prods.
thanks!
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
