Re: How to create unique constraint on NULL columns - Mailing list pgsql-general

From Ron Mayer
Subject Re: How to create unique constraint on NULL columns
Date
Msg-id 42D988A3.1060405@cheapcomplexdevices.com
Whole thread Raw
In response to Re: How to create unique constraint on NULL columns  ("Andrus" <eetasoft@online.ee>)
List pgsql-general
Andrus wrote:
>>Then redesign this as a many to many relation. ...
>
> This means adding separate row for each department into permission table.

Not really.

You can of course store an Array of department IDs in that same table.
That would probably cause the minimum impact on your queries too.

pgsql-general by date:

Previous
From: Ron Mayer
Date:
Subject: Re: Converting MySQL tinyint to PostgreSQL
Next
From: Michael Fuhr
Date:
Subject: Re: foreign key constraints and inheritence