I see, but in my case I want to define it myself - I don't expect group_concat to be implemented by Monet. Does this mean also that I cannot define any aggregate functions in MonetDB? thank you again, -- Asterios On Wed, Jul 18, 2012 at 5:25 PM, Martin Kersten wrote:

Hello

The message you refer too was a feature request. It is never implemented.

regards, Martin

On 7/18/12 4:53 PM, Asterios Katsifodimos wrote:

...

Hello,

I am trying to define an aggregate function as I have seen in an old message in this list: http://sourceforge.net/mailarchive/message.php?msg_id=20582949

I am trying to define it as: CREATE AGGREGATE group_concat (BASETYPE = text, SFUNC = _group_concat, STYPE = text);

And I get this error: 42000!syntax error, unexpected '=' in: "create aggregate group_concat (basetype ="

Any ideas on what I'm doing wrong? I have already defined the _group_concat function as described in the same message mentioned earlier.

Running MonetDB v11.9.5 (Apr2012-SP1) on Linux.

thank you, Asterios

------------------------------------------------------------------------------

...

Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

This works. I now have to define the MAL function. thank you, -- Asterios On Wed, Jul 18, 2012 at 5:56 PM, Stefan Manegold wrote:

Try

CREATE AGGREGATE group_concat (val STRING) returns STRING external name ""."group_concat";

where ""."group_concat" refers to the MAL function (with the proper signature) that you provide.

Stefan

----- Original Message -----

...

I see, but in my case I want to define it myself - I don't expect group_concat to be implemented by Monet.

Does this mean also that I cannot define any aggregate functions in MonetDB?

thank you again, -- Asterios

On Wed, Jul 18, 2012 at 5:25 PM, Martin Kersten wrote:

...

Hello

The message you refer too was a feature request. It is never implemented.

regards, Martin

On 7/18/12 4:53 PM, Asterios Katsifodimos wrote:

...

Hello,

I am trying to define an aggregate function as I have seen in an old message in this list: http://sourceforge.net/mailarchive/message.php?msg_id=20582949

I am trying to define it as: CREATE AGGREGATE group_concat (BASETYPE = text, SFUNC = _group_concat, STYPE = text);

And I get this error: 42000!syntax error, unexpected '=' in: "create aggregate group_concat (basetype ="

Any ideas on what I'm doing wrong? I have already defined the _group_concat function as described in the same message mentioned earlier.

Running MonetDB v11.9.5 (Apr2012-SP1) on Linux.

thank you, Asterios

---

...

...

...

Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

---

...

...

Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------

...

Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users