select avanced - Mailing list pgsql-hackers

From cristianopintado@gmail.com
Subject select avanced
Date
Msg-id b9e54b18-830d-4b9a-b21f-63439edf8139@x30g2000hsd.googlegroups.com
Whole thread Raw
Responses Re: select avanced
List pgsql-hackers
I have the following table:

Objeto        Valor

ob1        10
ob1        20
ob2        50
ob2        10
ob3        50

With the following command:

"select distinct Objeto, sum(valor) from tb
group by Objeto;"


I have to return:

Objeto        Valor

ob1        30
ob2        60
ob3        50

What you need to do is add ob2 and ob3 in one field,
Leading me the following table:


Objeto        Valor

ob1        30
ob2e3        110


It can do this only with Select?


pgsql-hackers by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: An idea for parallelizing COPY within one backend
Next
From: "Pavel Stehule"
Date:
Subject: proposal: plpgsql return execute ...