Re: multiset and procedure
Very interesting !
J.
Prasad Mujumdar wrote:
>
> 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
>
sending to informix-list