Unique constraint and NULL values
From: Agoston Bejo <gusz1_at_freemail.hu>
Date: Thu, 21 Oct 2004 14:45:56 +0200
Message-ID: <cl8ba7$d04$1_at_news.caesar.elte.hu>
I want to enforce such a constraint on a column that would ensure that the values be all unique, but this wouldn't apply to NULL values. (I.e. there may be more than one NULL value in the column.) How can I achieve this?
I suppose I would get the most-hated "table/view is changing, trigger/function may not see it" error if I tried to write a trigger that checks the uniqueness of non-null values upon insert/update. Received on Thu Oct 21 2004 - 14:45:56 CEST
Date: Thu, 21 Oct 2004 14:45:56 +0200
Message-ID: <cl8ba7$d04$1_at_news.caesar.elte.hu>
I want to enforce such a constraint on a column that would ensure that the values be all unique, but this wouldn't apply to NULL values. (I.e. there may be more than one NULL value in the column.) How can I achieve this?
I suppose I would get the most-hated "table/view is changing, trigger/function may not see it" error if I tried to write a trigger that checks the uniqueness of non-null values upon insert/update. Received on Thu Oct 21 2004 - 14:45:56 CEST