SELECT query experts, anyone? - Mailing list pgsql-general

From Teemu Juntunen
Subject SELECT query experts, anyone?
Date
Msg-id EC9F4F083ED8460FB3721179DFF54314@eng02
Whole thread Raw
Responses Re: SELECT query experts, anyone?  (Tino Wildenhain <tino@wildenhain.de>)
Re: SELECT query experts, anyone?  (Mark Roberts <mailing_lists@pandapocket.com>)
List pgsql-general
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?
 
Best regards and thanks,
Teemu Juntunen

pgsql-general by date:

Previous
From: "Roshni Mani"
Date:
Subject: Sequences using libpqxx
Next
From: Greg Smith
Date:
Subject: Re: WAL archiving to network drive