Re: where clause help - Mailing list pgsql-general

From Jorge Godoy
Subject Re: where clause help
Date
Msg-id 87ps5ubkpt.fsf@gmail.com
Whole thread Raw
In response to Re: where clause help  (Ketema <ketema@gmail.com>)
List pgsql-general
Ketema <ketema@gmail.com> 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      <jgodoy@gmail.com>

pgsql-general by date:

Previous
From: Brent Wood
Date:
Subject: Re: where clause help
Next
From: "Magicloud Magiclouds"
Date:
Subject: [pgsql] inherits and foreign key problem