Search Postgresql Archives

Re: How to enforce uniqueness when NULL values are present?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Christian Schröder wrote:
> How can I enforce these constraints?

I submit that you should rethink your database schema and properly 
normalize it.  You are attempting to retool the algebra that underlies 
the SQL functionalities into doing something they are not designed to 
do, and you will, even if you manage to solve this particular problem, 
be in a constant battle against the database system to get your 
application to behave in a consistent manner.

A first step in that direction would be to rethink the apparently 
troublesome use of null values.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux