Re: [MonetDB-users] SQL Case Statement

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