Thank you, Dariuszs. Where can I find documentation on this? http://monetdb.cwi.nl/SQL/Documentation/Queries.html does not seem to indicate that CASE statements are allowed. I was also wondering if I can designate aliases. The conventional syntax below does not seem to work: SELECT my_field [AS] f1 ... On Fri, Apr 16, 2010 at 10:19 AM, dariuszs <dariuszs@svnp.com> wrote:
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