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