[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Call for testing experimental patch
- Subject: Re: Call for testing experimental patch
- From: David Tangye <..hidden..>
- Date: Thu, 14 Sep 2006 19:38:00 +1000
On Wed, 2006-09-13 at 11:49 -0700, Chris Travers wrote:
> You misunderstand. id is unique within ap. It is not unique between
> ap and gl, for example.
I would have a table for each group of tables that has a unique id. Each
table suggests an entity that has not yet been
discovered/recognised/defined.
> I don't think that distinct adds anything.
It removes duplicates if there are any in the source table, thus is a
small data-scrubber. The default 'any' does not.