Re: uniqueness and null could benefit from a hint for dba

2019-10-23 Thread Tuomas Leikola
That is a nice design. You can create a regular unique index where columns(s)s are not null and then filtered index(es) for the cases where some of the unique columns are null. However my point, specifically, was that if the document in question would have offered alternative solutions, I personal

Re: uniqueness and null could benefit from a hint for dba

2019-10-29 Thread Tuomas Leikola
On Thu, Oct 24, 2019 at 5:31 PM Bruce Momjian wrote: > Uh, I am wondering if it is just too details for our docs. Can you > think of some text and its location? > > "Unique indexes on functions can be used to create special types of constraints, like considering unique values equal (coalesce) or