hi,

dose monetdb support returning multiple result sets by a stored procedure or a stored function?
something equevalent to this (mssql code):
create procedure p1 as
begin
select 'a' as f1;
select 'b' as f1, 'c' as f2
end;

any workaround??

i realized that if i do (in mclient terminal):
sql>select 'a' as f1; select 'b' as f1 ,'c' as f2; i get:

f1
--
a

f1|f2
-----
b |c

but this is not good enough for me. the actual procedures are long and complex, and i want to  gain the benefit of avoiding the re-compilation and reduced network traffic (in mssql it makes big difference for me).

i also realized that i can do:
create function f1() returns table...
but this is good for a single result only.

BTW: dose the monetdb-jdbc-driver support multiple result sets (java.sql.Statement.getMoreResult() etc.)?

thanks!