Postgres Pro
Downloads
Home   >   mailing lists

unique constraint with significant nulls? - Mailing list pgsql-general

From Mike Blackwell
Subject unique constraint with significant nulls?
Date
Msg-id CANPAkgvTFg+8axm-80C6cc3sXYkN-TwwsrzeNt99Os00gpK0Jw@mail.gmail.com
Whole thread Raw
Responses Re: unique constraint with significant nulls?
Re: unique constraint with significant nulls?
List pgsql-general
Tree view
How would one go about building a multi-column unique constraint where null is a significant value, eg. (1, NULL) <> (2, NULL)?

I see a number of references to not being able to use an index for this, but no mention of an alternative.  Any pointers would be appreciated

__________________________________________________________________________________
Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike.Blackwell@rrd.com
http://www.rrdonnelley.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: plpython2u not getting any output -> on independent script I get the desired output
Next
From: Daniele Varrazzo
Date:
Subject: Re: Running CREATE only on certain Postgres versions