db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John English <john.fore...@gmail.com>
Subject Re: Unique constraints and nulls
Date Mon, 19 May 2014 16:34:05 GMT
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

Mime
View raw message