Re: Unique is non unique; no nulls

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: <cbrazvan(at)laitek(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unique is non unique; no nulls
Date: 2007-09-22 19:09:06
Message-ID: 87vea2v7ot.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Razvan Costea-Barlutiu" <cbrazvan(at)laitek(dot)com> writes:

> Hello.
>
> Facts:
> 1. System: Win2003
> 2. Postgres 8.2

Is that just 8.2 or 8.2.x? Which x?

> This has way too many ramifications for me to follow so I do appreciate some
> guidance.

What do the outputs of these queries say?

select count(*),count(distinct suid) from mt;

select suid,count(*) from mt group by suid having count(*) > 1;

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-09-22 19:27:49 Re: Can't connect (2 dbs) or login (2 others)
Previous Message Morris Goldstein 2007-09-22 18:14:26 Can't connect (2 dbs) or login (2 others)