A. Kretschmer escribió:
> In response to Linos :
>> Hello,
>> i have a query that returns a result set like this:
>>
>> item | size | stock
>> 123 | XL | 10
>> 123 | XXL | 5
>> 123 | XS | 3
>>
>> and i would like get the results like this:
>>
>> item | XL | XXL | XS
>> 123 | 10 | 5 | 3
>
> Other solution with plain SQL:
>
> test=*# select * from linos ;
> item | size | stock
> ------+------+-------
> 123 | XL | 10
> 123 | XXL | 5
> 123 | XS | 3
> (3 rows)
>
> test=*# select item, sum(case when size='XL' then stock else 0 end) as
> "XL", sum(case when size='XXL' then stock else 0 end) as "XXL", sum(case
> when size='XS' then stock else 0 end) as "XS" from linos where item=123
> group by item;
> item | XL | XXL | XS
> ------+----+-----+----
> 123 | 10 | 5 | 3
> (1 row)
>
>
> Andreas
I think this approach have a problem (almost with my data), i have a somewhat
large number of different sizes, about 200 or so (although i have a presented a
limited example i now). Thanks anyway by the alternative way to do it Andreas.
Regards,
Miguel Angel.