Bugs item #2523265, was opened at 2009-01-20 11:32 Message generated for change (Settings changed) made by sjoerd You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2523265&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Documentation Group: SQL "stable" Status: Open Resolution: None Priority: 5 Private: No Submitted By: Jens Oehlschlägel (jens_oehl) >Assigned to: Niels Nes (nielsnes) Summary: SQL searched CASE supported but not documented Initial Comment: The documentation says in "F261-02 Searched CASE N" that searched CASE is not supported, but it appears to be supported since I could run statements like -- searched case expression SELECT numcol , CASE WHEN numcol < 6 THEN 'small' WHEN numcol = 6 THEN 'six' WHEN numcol > 6 AND numcol < 9 THEN '78' WHEN numcol IS NULL THEN 'NULL' ELSE 'big' END AS "NewColumnName" FROM sometable ; and not only -- simple case expression SELECT numcol , CASE numcol WHEN 6 THEN 'six' ELSE 'non-six' END AS "NewColumnName" FROM sometable ; ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2523265&group_id=56967 ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
