db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Enyedi <robert.eny...@intland.com>
Subject Derby support for COALESCE
Date Tue, 29 Aug 2006 13:13:41 GMT

How does Derby support the COALESCE function? While the reference manual 
briefly mentions that this is a reserved word and there is SQLSTATE 
42610 related to it, it does not get into details. The function seems to 
work but (in a certain scenario which I did not identify yet) it 
produces a server side NullPointerException.

The functionality of COALESCE(x1, x2, x3, ...) returns the first item 
from the list which is not null.

Is COALESCE supported in Derby or is there a well documented alternative 
function which does the same thing?


View raw message