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 +
nu
Ketema wrote:
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|0|1
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
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
---(end of broadcast)---
TIP 5: don't forget to increase your
D] On Behalf Of Ketema
> Sent: Monday, April 23, 2007 4:21 PM
> To: pgsql-general@postgresql.org
> 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
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 eliminat
