| From: | Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | unique constraint with significant nulls? |
| Date: | 2012-09-25 15:05:15 |
| Message-ID: | CANPAkgvTFg+8axm-80C6cc3sXYkN-TwwsrzeNt99Os00gpK0Jw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)Blackwell(at)rrd(dot)com
http://www.rrdonnelley.com
<http://www.rrdonnelley.com/>
* <Mike(dot)Blackwell(at)rrd(dot)com>*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniele Varrazzo | 2012-09-25 15:25:41 | Re: Running CREATE only on certain Postgres versions |
| Previous Message | Adrian Klaver | 2012-09-25 15:02:31 | Re: plpython2u not getting any output -> on independent script I get the desired output |