Excuse me, The original table is: order ID value ---------------------- 1 1000 3 2 1000 5 3 1000 6 1 1001 1 2 1001 2 1 1002 4 2 1002 4
The result of table should be: id value1 value2 value3 ---------------------------------------------------- 1000 3 5 6 1001 1 2 1002 4 4
Thanks! Regards,
--- On Thu, 5/5/11, Claudio Adriano Guarracino <elninon@yahoo.com> wrote:
From: Claudio Adriano Guarracino <elninon@yahoo.com> Subject: Select and merge rows? To: pgsql-sql@postgresql.org Date: Thursday, May 5, 2011, 4:18 PM
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!
