Select and merge rows?

From: Claudio Adriano Guarracino <elninon(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Select and merge rows?
Date: 2011-05-05 20:18:53
Message-ID: 139192.67117.qm@web161316.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello!
I have a doubt about a query that I tried to do, but I cant......
This is the scenario:
I have a table, with this rows:
order    ID    value   
----------------------
1    1000    3
2    1000    5
3    1000    6
1    1001    1
2    1001    2
1    1002    4
2    1002    4

I need to get this table, divided by ID, like this:
id    value1    value2    value3
--------------------------------
1000    3    5    6
1001    1    2
1002    1    2

How I can do this?
I tried with cursors and view, but i can't....
Any help is welcome!

Thanks in advance!
Regards,

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oliveiros 2011-05-05 20:24:54 Re: Select and merge rows?
Previous Message Tarlika Elisabeth Schmitz 2011-05-05 15:21:38 Re: data import via COPY, Rules + Triggers