Bugs item #2523265, was opened at 2009-01-20 10:32 Message generated for change (Settings changed) made by nielsnes 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: Martin Kersten (mlkersten) 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 ------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
