Bugs item #2523265, was opened at 2009-01-20 11:32 Message generated for change (Comment added) made by mlkersten 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: Closed >Resolution: Fixed 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 ; ---------------------------------------------------------------------- >Comment By: Martin Kersten (mlkersten) Date: 2009-02-12 23:14 Message: fixed in documentation ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2523265&group_id=56967 ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
