Message-ID: <3D814DEB.6090807@oasis.net.au>
Date: Fri, 13 Sep 2002 12:31:07 +1000
From: Rudi Starcevic <rudi@oasis.net.au>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.1) Gecko/20020826
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: DISTINCT
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

I'd like to select from one table ( contains duplicates ) into a new table.
However the new table is exactly the same as the original ( duplicates 
included )
I think I have a problem with my DISTINCT clause - sql below.

It seems the DISTINCT is applied to the whole row not just the 'phone' 
field.
Is the a way I can select the whole row into a new table based on a DISTINCT
phone number ?

Is the a way I can select the whole row into a new table based on a DISTINCT
phone number and state ?


Else I'll need to select into a table then select again etc,etc ....to 
remove duplicates.

SELECT
    DISTINCT phone,
    company_name,
    address,
    state,
    idc_desc_1,
    street_number,
    street_name,
    street_xtra,
    suburb,
    postcode,
    area_code,
    ac_phone,
    fax_area_code,
    fax_phone,
    fax_ac_phone,
    latitude,
    longitude
INTO export_temp
FROM export;

Thanks
Rudi