pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Query to eliminate duplicates
3+ messages / 2 participants
[nested] [flat]

* Query to eliminate duplicates
@ 1998-12-02 09:43 Mario Filipe <mjnf@uevora.pt>
  1998-12-02 16:23 ` Re: [SQL] Query to eliminate duplicates Sferacarta Software <sferac@bo.nettuno.it>
  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 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   ` Re: [SQL] Query to eliminate duplicates 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-02 09:43 Query to eliminate duplicates Mario Filipe <mjnf@uevora.pt>
  1998-12-02 16:23 ` Re: [SQL] Query to eliminate duplicates Sferacarta Software <sferac@bo.nettuno.it>
@ 1998-12-03 08:59   ` Mario Filipe <mjnf@uevora.pt>
  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