let ff your table...
try this:
select
a.id,
a.date,
a.hours,
(select sum(b.hours)
from ff as b
where a.id = b.id
group by b.id
) as a
from ff as a;
bye,
Luca
Henry Ortega ha scritto:
I have the ff data:
id | date |
I need to know if somebody read this mail.
bye
Hi all,
There’s a behaviour I can’t understand
There is table TABLE_A with 3 columns (uid, id, session)
where uid is the pk and the data type is serial.
There is table TABLE_B with 3 columns (uid, ts_col, col)
where uid is the pk.
On table TABLE_A I have a rule on insert like thi
