From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Shavonne Marietta Wijesinghe <shavonne(dot)marietta(at)studioform(dot)it> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: SELECT DISTINCT |
Date: | 2008-02-19 13:51:10 |
Message-ID: | 47BADECE.7050603@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Shavonne Marietta Wijesinghe wrote:
> Hello
>
> I have 2 records with the same value. Even when i do a select with
> DISTINCT, it returns me both the records instead of one.
>
> SELECT DISTINCT ON (TE_COGNOME) TE_COGNOME, TE_NOME, N_GEN_TEST,
> TE_SESSO, TE_ATTNASC, TE_LUONASC, TE_INDI, TE_DTNASC, TE_PROVSTATO,
> TE_PROV, TE_PATERNITA, TE_RICHIESTA FROM MOD48_02 WHERE TE_COGNOME
> LIKE 'WIJ%' AND TRIM(DELETED) IS NULL ORDER BY TE_COGNOME, N_GEN_TEST
> DESC;
Can you provide:
1. The output of your query (just the duplicate rows will be fine)
2. The output of "\d MOD48_02"?
3. The output of:
SELECT xmin,xmax, ':' || TE_COGNOME || ':' FROM MOD48_02
WHERE TE_COGNOME = ???
For the duplicate value of course
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Stuart Brooks | 2008-02-19 14:05:23 | Re: Am I wasting my time with partitions? |
Previous Message | Richard Huxton | 2008-02-19 13:48:12 | Re: Am I wasting my time with partitions? |