RE: multiset and procedure
You need to use following :
create function RetArr() returning integer
return 1 with resume; return 2 with resume;
return 3 with resume;
end function;
select * from table (function RetArr()) mytable(id);
id
1
2
3
3 row(s) retrieved.
thanx
Prasad
>From: "M.Kovacic" <nospam_matej_nospam_kovacic@snt.si>
>Reply-To: "M.Kovacic" <nospam_matej_nospam_kovacic@snt.si>
>To: informix-list@iiug.org
>Subject: multiset and procedure
>Date: Wed, 4 May 2005 21:11:19 +0200
>
>Hi all,
>
>have a question; what I'm doing wrong or is this not possible; (ids 9.4)
>
>create procedure RetArr() returning integer as id;> return 1 with resume;
> return 2 with resume;
> return 3 with resume;
>end procedure ;
>
>select * from table(multiset (execute procedure RetArr() ))>-> this statement causes error, is this casting invalid is any way to use
>"multirows" procedure in SELECT statemant??
>
>thanks and regards,
>Matej
>
>
_________________________________________________________________
NRIs, Choose the best solution.
http://creative.mediaturf.net/creatives/citibankrca/rca_msntagofline.htm
With Citibank Rupee Checking Account!
sending to informix-list