select case when column1 is null then 'Absent' else 'Present' end from table1; Hering Cheng wrote:
Hi,
Is there any plan to add support for CASE in SELECT clauses to MonetDB?
Thanks. Hering ------------------------------------------------------------------------
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ------------------------------------------------------------------------
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users