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 <elni...@yahoo.com> wrote: From: Claudio Adriano Guarracino <elni...@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! Thanks in advance! Regards,
