Received: from neptuno.uevora.pt (neptuno.sc.uevora.pt [193.136.216.24]) by hub.org (8.9.1/8.9.1) with ESMTP id KAA26438 for ; Fri, 4 Dec 1998 10:42:47 -0500 (EST) (envelope-from mjnf@neptuno.sc.uevora.pt) Received: (from mjnf@localhost) by neptuno.uevora.pt (8.9.1a/8.9.1/Debian/GNU) id PAA12166; Fri, 4 Dec 1998 15:42:25 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:981204154224:11993=_"; micalg=pgp-md5; protocol="application/pgp-signature" In-Reply-To: <5658.981204@bo.nettuno.it> Date: Fri, 04 Dec 1998 15:42:24 -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: Re[4]: [SQL] Query to eliminate duplicates Cc: pgsql-sql@postgresql.org This message is in MIME format --_=XFMail.1.3.p0.Linux:981204154224:11993=_ Content-Type: text/plain; charset=iso-8859-1 > select * from cursos; > numero_aluno|codigo_disciplina|ano_lectivo|epoca|semestre > ------------+-----------------+-----------+-----+-------- > 13427| 35|1998/1999 | 1|t > 13427| 904|1998/1999 | 1|f > 13427| 122|1998/1999 | 1|t > 13427| 907|1998/1999 | 1|f > 13427| 481|1998/1999 | 1|f > 13427| 286|1998/1999 | 1|t > 13427| 368|1998/1999 | 1|t > 13427| 35|1998/1999 | 1|t > 13427| 904|1998/1999 | 1|f > 13427| 122|1998/1999 | 1|t > (10 rows) > > create table temp as select distinct * from cursos; > SELECT > select * from temp; > numero_aluno|codigo_disciplina|ano_lectivo|epoca|semestre > ------------+-----------------+-----------+-----+-------- > 13427| 35|1998/1999 | 1|t > 13427| 122|1998/1999 | 1|t > 13427| 286|1998/1999 | 1|t > 13427| 368|1998/1999 | 1|t > 13427| 481|1998/1999 | 1|f > 13427| 904|1998/1999 | 1|f > 13427| 907|1998/1999 | 1|f > (7 rows) > > DROP TABLE cursos; > DROP > alter table temp rename to cursos; > RENAME Thanks! I had thought about this a while ago... but then I forgott it! Mario Filipe mjnf@uevora.pt http://neptuno.sc.uevora.pt/~mjnf (modificada em 26/11/98) --_=XFMail.1.3.p0.Linux:981204154224:11993=_ Content-Type: application/pgp-signature -----BEGIN PGP MESSAGE----- Version: 2.6.3ia iQEVAwUBNmgC3piyznf+xIrhAQHwbAf/T4EpQi5DH2vRQ17Jhkg1TUYc+7lNjZtA HoppznIqGHxzxeHBodG1Fhch6703VmX1+1Cvcp22e5JBiURJVD4pb9sQK/J3vX5K Jl/0XTQ9tgqG8SbaZkRo54AZR/BYVeeqinaDAfvOuoas4u77Hrd9Hom7JR+ZHWVE YwZ1CBOjrGtxonQhzBpnVU4a5cRBH0DfLbgvAHd/xrx/wV2yoFDRkTbri5A43s1E c+HYKWQlz2GrpcYu34bo4IxYMfsxiWsFlTjzNWlBCiT0jXPJLpSJiFCuAWGlwE0F R9mH59GWRENgN1/Xb00nkXYDyCLny/+q7UecNHPCvtRYSvnz5JpF3g== =5iCD -----END PGP MESSAGE----- --_=XFMail.1.3.p0.Linux:981204154224:11993=_-- End of MIME message