Re: Unique constraints and nulls

[John English]

On 19/05/2014 15:22, Dyre Tjeldvoll wrote:

I think you then can do

DELETE FROM WITH_NULLS WHERE A = ? AND
    CASE WHEN ? IS NULL THEN B IS NULL ELSE B = ? END

Nice idea (but the unique index solution is better). Thanks for helping!
--
John English