Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 378449FB32A for ; Tue, 6 Feb 2007 19:15:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 69775-07 for ; Tue, 6 Feb 2007 19:15:34 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 0B0C09FB324 for ; Tue, 6 Feb 2007 19:15:34 -0400 (AST) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1HEZX6-0004pR-Md for pgsql-sql@postgresql.org; Wed, 07 Feb 2007 00:15:28 +0100 Received: from ppp-82-135-12-176.dynamic.mnet-online.de ([82.135.12.176]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 07 Feb 2007 00:15:28 +0100 Received: from spam_eater by ppp-82-135-12-176.dynamic.mnet-online.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 07 Feb 2007 00:15:28 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: Thomas Kellerer Subject: Re: Removing duplicate rows Date: Wed, 07 Feb 2007 00:15:18 +0100 Lines: 13 Message-ID: References: <45C8FDE6.6050603@autoledgers.com.au> <20070206222238.GA28647@phlogiston.dyndns.org> <45C904B9.40407@autoledgers.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: ppp-82-135-12-176.dynamic.mnet-online.de User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.0.9) Gecko/20061207 Thunderbird/1.5.0.9 Mnenhy/0.7.4.0 In-Reply-To: <45C904B9.40407@autoledgers.com.au> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/59 X-Sequence-Number: 27393 Paul Lambert wrote on 06.02.2007 23:44: > Sort on Weenblows is a bastard to work with, and I don't believe it has > a unique option. I probably should have mentioned this was on Weenblows. You can get all (or most?) of the *nix/GNU commandline tools for Windows as well. As "native" Win32 programs that do not require a pseudo *nix (aka as Cygwin) to run in: http://gnuwin32.sourceforge.net tsort and uniq are part of the coreutils package Thomas