Re: where clause help

From: Jorge Godoy <jgodoy(at)gmail(dot)com>
To: Ketema <ketema(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: where clause help
Date: 2007-04-24 01:54:38
Message-ID: 87ps5ubkpt.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ketema <ketema(at)gmail(dot)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(at)gmail(dot)com>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2007-04-24 02:15:59 Re: Postgresql Help
Previous Message Brent Wood 2007-04-24 01:08:23 Re: where clause help