From: Rob Sargent <robjsargent@gmail.com>
To: Gary Chambers <gwchamb@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Duplicates Processing
Date: Fri, 08 Oct 2010 17:47:57 -0600
Message-ID: <4CAFADAD.7060600@gmail.com> (raw)
In-Reply-To: <AANLkTi=DiRzwbcrOx8-Y52=oM4GBmA7MEAOb1VvnZcU8@mail.gmail.com>
References: <AANLkTinSF+zqTVHbHp5HgN0TwHX-DjLAwQ4LhE7FYFxZ@mail.gmail.com>
<m3iq1cr0fi.fsf@passepartout.tim-landscheidt.de>
<AANLkTinr=cNsOeMGfOAjg5ncWhQ9p4RbpfyaoV1YN66T@mail.gmail.com>
<4CAF79EB.1080606@gmail.com>
<AANLkTimRfzKH0DhyuMLpeU3g5GnCU6CuzYdxcph5HjqL@mail.gmail.com>
<4CAF8E64.8010000@gmail.com>
<AANLkTi=DiRzwbcrOx8-Y52=oM4GBmA7MEAOb1VvnZcU8@mail.gmail.com>
My understanding was that the values were in fact in the data of the
"replacers". If not, you are correct. In this case the replacers are
more like alias for the only instance you have.
If the replacers are immutable by all means ship them off to some other
table (where I suppose the become pointers to other suppliers of the
type of thing holding the real data). Not sure I've ever met immutable
data but there you go ;)
And to your point of self-reference, it would be to a co-worker more
than a manager. Managers are often not good replacements for workers. :)
On 10/08/2010 04:12 PM, Gary Chambers wrote:
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: robjsargent@gmail.com, gwchamb@gmail.com
Subject: Re: Duplicates Processing
In-Reply-To: <4CAFADAD.7060600@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox