Ketema <[EMAIL PROTECTED]> writes: > Man so simple! is your solution the same as: > > num_provisioned < num_products AND (num_open_issues + num_provisioned > + num_canceled) < num_prods > > which is what i finally came up with....
This can be simplified to "num_open_issues + num_provisioned + num_canceled < num_prods", without the AND and the other statement. -- Jorge Godoy <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/