Re: How does PostgreSQL treat null values in unique composite - Mailing list pgsql-admin

From Michael Brusser
Subject Re: How does PostgreSQL treat null values in unique composite
Date
Msg-id DEEIJKLFNJGBEMBLBAHCIEHFDAAA.michael@synchronicity.com
Whole thread Raw
In response to How does PostgreSQL treat null values in unique composite constraints???  (P G <pg_dba@yahoo.com>)
List pgsql-admin
I suppose null is 'absence of value' rather than any
value (like an empty string) that can be compared with any
other value for uniqueness.
Mike.


> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of P G
> Sent: Tuesday, April 08, 2003 2:14 PM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] How does PostgreSQL treat null values in unique
> composite constraints???
>
>
> I have the following table with a unique constraint.
>
> create table testt (
> id int,
> aa int,
> bb int,
> constraint pk_testt primary key (id),
> constraint cons_testt unique (aa,bb));
>
> Let's say I insert the following:
>
> insert into testt values (1,2,null);
> insert into testt values (2,2,null);
>
> I thought this should fail because of the unique
> constraint, but it doesn't.  How does PostgreSQL view
> the null values in this constraint?  Will someone
> explain why I am allowed to make this insertion?
>
> TIA.
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - File online, calculators, forms, and more
> http://tax.yahoo.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>


pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: How does PostgreSQL treat null values in unique composite
Next
From: Tom Lane
Date:
Subject: Re: pg_class.reltuples not reset by VACUUM?