Re: SQL "transpose" question

From: "bozon" <curtis@xxxxxxxxxxxx>
Date: 30 Mar 2006 08:19:46 -0800

select
ppl_id,
multiset(select item inner_s.code from source inner_s where
inner_s.ppl_id = outer_s.ppl_id)::lvarchar,
replace(replace(substr(multiset(select item inner_s.code from source
inner_s where inner_s.ppl_id = outer_s.ppl_id)::lvarchar, 10),
"}"),"'")
from
source outer_s
;

Also I assumed that codes(20) was really codes lvarchar or varchar(20).

.

References:
- SQL "transpose" question
  - From: kasis_100

Prev by Date: Hardware Comparison between SUN E6900 and IBM P570
Next by Date: Re: Hardware Comparison between SUN E6900 and IBM P570
Previous by thread: SQL "transpose" question
Next by thread: Re: SQL "transpose" question
Index(es):
- Date
- Thread