While it is nice to know that CASE expression is listed under F261, I am still unable to find actual examples in the Feb2010 source code.  The source code does contains some very simple SQL statements for testing, but none that seems to make use of more advanced features.

I think an updated documentation of the complete SQL syntax is fairly important.  Without it, people who are evaluating MonetDB may come to the wrong conclusion about MonetDB's capabilities.

Can someone provide me with the actual path of the source code file that has examples for this and other SQL features?

On Fri, Apr 23, 2010 at 9:43 AM, Martin Kersten <Martin.Kersten@cwi.nl> wrote:
Hering Cheng wrote:
Thank you, Dariuszs.
For an overview see
http://monetdb.cwi.nl/SQL/Documentation/SQL-Features.html

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 <mailto: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&#174; 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
       <mailto:MonetDB-users@lists.sourceforge.net>

       https://lists.sourceforge.net/lists/listinfo/monetdb-users
       





------------------------------------------------------------------------

------------------------------------------------------------------------------



------------------------------------------------------------------------

_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users