[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 03:18:18 +1000
On Mon, 2006-09-11 at 22:49 -0700, Chris Travers wrote:
> This patch will hopefully get included with the next version but I
> want to put it through some more vetting first. I am testing it on my
> production machines.
A small thought: Would 'distinct' and 'order by' improve it? distinct
will merge duplicate values, and order by .. well why not?
eg
insert into id_tracker (id, table_name) SELECT distinct id, 'ap' FROM ap
order by id;