Re: Dynamic Queries

Hi No. Aside from missing details (e.g. attributes), the sketched procedure can not be statically typechecked for correctness, because the expression is evaluated at runtime. On 15/06/16 00:00, Ariel Abadi wrote:

Hi

Im trying to create a Procedure to create (or not) tables dynamically. Does Monet can do something like the following??

CREATE PROCEDURE(pdate date, tname varchar(10)) BEGIN SET TABLENAME = CONCAT(tname, '_', YEAR(pdate)*100+MONTH(pdate));

CREATE TABLE IF NOT EXIST TABLENAME;

END

Thanks in advance! Rgds

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list