SELECT query experts, anyone?

From: "Teemu Juntunen" <teemu(dot)juntunen(at)e-ngine(dot)fi>
To: "PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: SELECT query experts, anyone?
Date: 2008-08-20 12:50:49
Message-ID: EC9F4F083ED8460FB3721179DFF54314@eng02
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2008-08-20 12:59:13 Re: WAL archiving to network drive
Previous Message Roshni Mani 2008-08-20 10:13:54 Sequences using libpqxx