This works. I now have to define the MAL function.

thank you,
--
Asterios


On Wed, Jul 18, 2012 at 5:56 PM, Stefan Manegold <Stefan.Manegold@cwi.nl> wrote:
Try

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

where "<your_modulename>"."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
> <Martin.Kersten@cwi.nl>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