Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org (8.9.1/8.9.1) with ESMTP id NAA10757 for ; Thu, 3 Dec 1998 13:58:01 -0500 (EST) (envelope-from mjnf@neptuno.sc.uevora.pt) Received: from neptuno.uevora.pt (neptuno.sc.uevora.pt [193.136.216.24]) by trends.net (8.8.8/8.8.8) with ESMTP id DAA28366 for ; Thu, 3 Dec 1998 03:59:59 -0500 (EST) Received: (from mjnf@localhost) by neptuno.uevora.pt (8.9.1a/8.9.1/Debian/GNU) id IAA06456; Thu, 3 Dec 1998 08:59:22 GMT Message-ID: X-Mailer: XFMail 1.3 [p0] on Linux X-Priority: 3 (Normal) MIME-Version: 1.0 Content-Type: multipart/signed; boundary="_=XFMail.1.3.p0.Linux:981203085921:11500=_"; micalg=pgp-md5; protocol="application/pgp-signature" In-Reply-To: <18724.981202@bo.nettuno.it> Date: Thu, 03 Dec 1998 08:59:21 -0000 (WET) X-Face: "9hSo9W{D!]@5,5u$o~%u; Y'Jd-soHe$zeqc1MFu&mlE; af,Hbz}V,Le1_5)/fK@@P/#_+, `6TSkyHf39(-wxNK9gi$Oin`[S|xWBJ0T8gQ, m[h$1b?1"}SEpxt+:H-m+%h7|Wy)hM-3, cbg3Y8Y> YJIYJu= Reply-To: mjnf@uevora.pt Organization: Universidade de Evora Sender: mjnf@neptuno.sc.uevora.pt From: Mario Filipe To: Sferacarta Software Subject: Re: [SQL] Query to eliminate duplicates Cc: pgsql-sql@postgresql.org This message is in MIME format --_=XFMail.1.3.p0.Linux:981203085921:11500=_ Content-Type: text/plain; charset=iso-8859-1 On 02-Dec-98 Sferacarta Software wrote: > MF> Is there a way to eliminate duplicate records using just SQL? > > SELECT DISTINCT ... I deserved that! The problem is that i have a table where there are duplicate records and i want to delete them! I tryed creating a unique index but it told me it couldn't because it didn't have a function to do something (I think it is because i had a boolean field in it) Thanks P.S : I've looked in ther archive and found that there were others who made the same question yet never got an anwser... Mario Filipe mjnf@uevora.pt http://neptuno.sc.uevora.pt/~mjnf (modificada em 26/11/98) --_=XFMail.1.3.p0.Linux:981203085921:11500=_ Content-Type: application/pgp-signature -----BEGIN PGP MESSAGE----- Version: 2.6.3ia iQEVAwUBNmZS55iyznf+xIrhAQFmzwgAu6zwfs+CmLLvGc+qvNcg24dwDL7p7yZw ZYrEPu+ScZqvDkJ/HvTfapVuEiRXQHMrcjDO3R1tLvXs036bbkyV1pJjuIgfZcU0 Gx1f0A9OEhkj2gOhosEY3unMcAFDGHQSFD0aPkN48iS+t7b/vFIGluYHCYxXpR1P yz77PP4wBxolhICvfkSqefB7SFJyLW952DUHFGOaCUB8W7R6Mq2yrEaKWlkKgJXd vbVvdzPqukuMsAB7xogh7nld6aywcWW3k5aHSGw4e8kAdB6SMPDUj+GybzwxbYFq ilrtsmmujIMPXJgWotOU8s/UXHNBRPkXMhBBncrAE4cQNIjlhdNC4w== =ZkUh -----END PGP MESSAGE----- --_=XFMail.1.3.p0.Linux:981203085921:11500=_-- End of MIME message