how to select with multicast
70836Sep 5 2007 — edited Sep 21 2007If I define a type of object and create a view using it:
+++++++++
create view v1 as
select cast(multiset(select
m.name as mName,
m.id as mId
from mtable m as mlist) mlst
from sometable
+++++++++
is it possible for me to select the above view by using the where statement on the mName or mId?
I try this and did not work:
select * from v1 where mlst(mName) = 'a'
What should the syntax be?
Thanks.