[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [ShopSuite-dev] new shop.psql
|
From: |
Tomasz Wegrzanowski |
|
Subject: |
Re: [ShopSuite-dev] new shop.psql |
|
Date: |
Tue, 21 Aug 2001 17:09:27 +0200 |
|
User-agent: |
Mutt/1.3.20i |
On Tue, Aug 21, 2001 at 03:31:40PM +0100, Davi Leal wrote:
> CREATE VIEW ProdsToSell
> CREATE VIEW ProdsToBuy
>
> [...]
> FROM products
> WHERE NOT inactivation [...]
>
> moved to
>
> [...]
> FROM products
> WHERE active [...]
>
> Right?
There's a question whether we need active if we have inactivation
that may be NULL. I prefer second version, as active field gives no new data.
Following is always true:
active ::= (inactivation != NULL)