Re: [MonetDB-users] Is there IF(), IFNULL() in SELECT?

On 30-08-2012 17:02:15 -0400, Dmitry Insta wrote:

Sorry if it was asked before, I can't find a comprehensive list of functions available. Is it possible to somehow implement something like this:

SELECT IF(col1>0,'Negative','Positive') as Sign, IFNULL(col2,'Empty',col2) as col2 FROM table;

SELECT CASE WHEN col1 > 0 THEN 'Negative' ELSE 'POSITIVE' END AS "Sign", CASE WHEN col2 IS NULL THEN 'Empty' ELSE col2 END AS col2 FROM table;

You may need explicit casts to make the strings from the WHEN and ELSE clauses fit/be compatible.