Re: SELECT query experts, anyone?

[Tino Wildenhain <tino@xxxxxxxxxxxxx>]

Teemu Juntunen wrote:
> Hi Experts,
>  
> is threre any way to SELECT values in columns instead of rows? For 
> example select products and their manufacters in the followin way:
>  
> product1; manufacturer1; manufacturer2;,,, manufacturerN
> product2; manufacturer3;
> product3; manufacturer1;.. manufacturerN-1
>  
> With a function you could put the product manufacturers in one string, 
> but I would like to have them in columns. 
>  
> How about arrays. Is there a way to SELECT values in an array to columns?

This should work:

SELECT product,array(SELECT manufacturer FROM manufacturers WHERE 
manufacturer_id=products.manufacturer_id) WHERE ...

or something along the lines of the above.

Regards
Tino

<<attachment: smime.p7s>>