where num_prods > num_open_issues + num_provisioned + num_canceled if those columns are nullable (which they don't seem to be) you'd have to convert the NULLs (i.e. coalesce(num_canceled,0) ) > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Ketema > Sent: Monday, April 23, 2007 4:21 PM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: [GENERAL] where clause help > > 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! >
