pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Francisco Hernandez <xy0xy0@earthlink.net>
To: pgsql-sql@postgresql.org
Subject: eliminating duplicates in results..
Date: Wed, 21 Jun 2000 16:53:41 -0700
Message-ID: <39515585.308A428C@earthlink.net> (raw)

hello everyone,
i have a query like so:

select item.type as ig_id,item.with_design,item_group.type as
group_name, 'true' as valid from item,item_group where item.description
~* 'w/out' and item.type = item_group.ig_id;

and i get duplicates.. how could i remove all the duplicate entrys using
SQL?
the duplicates are fine.. im just trying to migrate data from one table
to another.. with columns renamed and some added/removed..




view thread (2+ messages)  latest in thread

Message-ID: <39515585.308A428C@earthlink.net>
Permalink:  ../39515585.308A428C@earthlink.net/
Also on:    postgresql.org/message-id/39515585.308A428C@earthlink.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: xy0xy0@earthlink.net
  Subject: Re: eliminating duplicates in results..
  In-Reply-To: <39515585.308A428C@earthlink.net>
  References: <39515585.308A428C@earthlink.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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