Selecting duplicates

From: ghoffman(at)ucsd(dot)edu (Gary Hoffman)
To: pgsql-general(at)hub(dot)org
Subject: Selecting duplicates
Date: 1999-08-06 07:14:27
Message-ID: fc.00249f0e0038836300249f0e00388363.388367@irpsbbs.ucsd.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Somehow, I've managed to get duplicate entries in my soon-to-be primary
key field. How can I select for duplicates in a field? I know how to
select for blank and NULL, but duplicates escape me.

Thanks,
Gary

**************************************************************************
* Gary B. Hoffman, Computing Services Manager e-mail: ghoffman(at)ucsd(dot)edu *
* Graduate School of International Relations and Pacific Studies (IR/PS) *
* University of California, San Diego (UCSD) voice: (858) 534-1989 *
* 9500 Gilman Dr., La Jolla, CA 92093-0519 USA fax: (858) 534-3939 *
**************************************************************************

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adriaan Joubert 1999-08-06 07:45:11 Re: [GENERAL] Selecting duplicates
Previous Message Postgres SQL 1999-08-06 06:55:44 Re: subscribe