pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedQuery to eliminate duplicates
3+ messages / 2 participants
[nested] [flat]
* Query to eliminate duplicates
@ 1998-12-02 09:43 Mario Filipe <mjnf@uevora.pt>
0 siblings, 1 reply; 3+ messages in thread
From: Mario Filipe @ 1998-12-02 09:43 UTC (permalink / raw)
To: pgsql-sql
Hi
Is there a way to eliminate duplicate records using just SQL?
Thanks
Mario Filipe
mjnf@uevora.pt
http://neptuno.sc.uevora.pt/~mjnf (modificada em 26/11/98)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] Query to eliminate duplicates
@ 1998-12-02 16:23 Sferacarta Software <sferac@bo.nettuno.it>
parent: Mario Filipe <mjnf@uevora.pt>
0 siblings, 1 reply; 3+ messages in thread
From: Sferacarta Software @ 1998-12-02 16:23 UTC (permalink / raw)
To: pgsql-sql@postgresql.org, Mario Filipe <mjnf@uevora.pt>
MF> Is there a way to eliminate duplicate records using just SQL?
SELECT DISTINCT ...
-Jose'-
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] Query to eliminate duplicates
@ 1998-12-03 08:59 Mario Filipe <mjnf@uevora.pt>
parent: Sferacarta Software <sferac@bo.nettuno.it>
0 siblings, 0 replies; 3+ messages in thread
From: Mario Filipe @ 1998-12-03 08:59 UTC (permalink / raw)
To: Sferacarta Software <sferac@bo.nettuno.it>; +Cc: pgsql-sql
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)
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1998-12-03 08:59 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-12-02 09:43 Query to eliminate duplicates Mario Filipe <mjnf@uevora.pt>
1998-12-02 16:23 ` Sferacarta Software <sferac@bo.nettuno.it>
1998-12-03 08:59 ` Mario Filipe <mjnf@uevora.pt>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox