Martin, Thanks for your reply. I am using the sql frontend only. I just had a look at the functions table and now see all the string/data extraction primitives. I am particularly interested in mimicking the PostgreSQL functionality (which is our main transactional/etl system). BTW, we typically want to do ad-hoc stuff like:
select to_char(charge_date, 'yyyy-mm') , sum(actual_consump_adj) , sum(billed_consump_adj) , count(*) from consumption group by to_char(charge_date, 'yyyy-mm') order by to_char(charge_date, 'yyyy-mm') ;
Cheers, Kirk. Martin Kersten wrote:
Dear Kirk,
Thank you for your interest in using MonetDB. Can you be more specific on the front-end you are using, e.g. SQL or XQuery. The SQL comes with several string/date extraction primitieves. It may help to understand your request by excemplifying the reference system you have in mind, e.g. MySQL, PostgreSQL,...
regards, Martin
Kirk Abbott wrote:
Hello,
We are trying to move some data over to Monetdb and are finding that we are missing some of our favorite formatting functions (to_date, to_char etc.). Does Monetdb have a user defined functions extension framework? If so, we would try to mimic these functions there.
Thanks, Kirk.
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users