Re: [BUGS] BUG #5005: unique constraint considers nulls to be equal

2009-08-23 Thread Alvaro Herrera
Dean Schulze wrote: > Here are the duplicate records that violate this constraint: > > select county, year, idnumber, count(0) from table1 group by county, year, > idnumber having (count(0) > 1) order by county, count(0); > > > "county","year","idnumber","count" > "AD",2009,"A57504",2 > "AD",20

[BUGS] BUG #5005: unique constraint considers nulls to be equal

2009-08-23 Thread Dean Schulze
The following bug has been logged online: Bug reference: 5005 Logged by: Dean Schulze Email address: dean.w.schu...@comcast.net PostgreSQL version: 8.3.7 Operating system: Win XP Description:unique constraint considers nulls to be equal Details: When I apply this co