I'm in the process of writing a patch to get the driver to handle
multiple out parms.
One mechanism is to create a composite type and a function such as:
create type Numeric_Proc_RetType as(it1 numeric(30,15),it2
numeric(30,15),it3 numeric(30,15));");
create function Numeric_Proc(numeric(30,15),numeric(30,15),
numeric(30,15)) returns Numeric_Proc_RetType as 'declare work_ret
record; begin select * into work_ret from Numeric_Tab; return work_ret;
end;' language 'plpgsql';
Are there any problems with this ?
Dave
--
Dave Cramer
519 939 0336
ICQ # 14675561