Re: Duplicates Processing - Mailing list pgsql-sql

From Gary Chambers
Subject Re: Duplicates Processing
Date
Msg-id AANLkTi=DiRzwbcrOx8-Y52=oM4GBmA7MEAOb1VvnZcU8@mail.gmail.com
Whole thread Raw
In response to Re: Duplicates Processing  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Duplicates Processing  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-sql
Rob,

> Yes.  With this you can find all part numbers/supplies which match your
> value, wattage criteria in one table. Or exclude any which have a
> non-null is_replacement_for value.

I understand -- thanks.  I have received contradictory advice in a
purely data modeling context.  What about the null values that will be
in the properties columns of the part?  It would appear to be more
applicable to an employee database where the columns are populated
regardless and the "replacement_for" in the context of our discussion
would be a self-reference to the employee's manager.  No?

Thanks again for your help.

-- Gary Chambers


pgsql-sql by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Duplicates Processing
Next
From: James Cloos
Date:
Subject: counting related rows