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 ...
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