[MonetDB-users] pcre exception with LIKE inside CASE

Hi, I can successfully run the following query: select "field1", "field2" from testlike where field2 like '%hel%' However, I cannot run this one: select "field1", "field2", (case when ("field2" like '%hel%') then cast("field1" as double) else cast("field1" as bigint) end) as dd from testlike I get this exception: !MALException:pcre_match:not available as required version of libpcre was not found by configure. (This is on Feb SP2 2009 compiled on Windows from CVS) -- View this message in context: http://www.nabble.com/pcre-exception-with-LIKE-inside-CASE-tp23694479p236944... Sent from the monetdb-users mailing list archive at Nabble.com.