Hello,
Is it possible write stored procedure (sorry, function) which will
return tuples one by one. Like:
select * from my_func(1,2,3);
1 Ivan
2 Petr
3 Irzi
etc.
Like in, for example, Interbase (this is completely unnatural proc):
create procedure find_something_for(p integer, w integer)
returns (k integer, t varchar(30) )
as
begin
for select n,v from t001 into :k,:t do
begin
if(n>10) then suspend;
end
end
'suspend' will return result to caller and then execution will continue
from saved position.
This is needed when computations is much harder than comparision n and 10
--
Igor Roboul, Unix System Administrator & Programmer @ sanatorium "Raduga",
Sochi, Russia
http://www.brainbench.com/transcript.jsp?pid=304744
