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
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