Hi, Download the sources and look at the examples, the online documentation is outdated (especially for php). Dariusz.

Hering Cheng wrote:

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

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

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