Re: [MonetDB-users] SQL Case Statement

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