Re: [SQL] select sum within transaction problem

2007-09-11 Thread Tom Lane
"Bart Degryse" <[EMAIL PROTECTED]> writes: > I have a function like below (simplified). Everything works the way I want = > it to except for one thing. > After the select statement sum_revenues is NULL instead of the real sum. > Has this something to do with the earlier deletes and inserts not bein

[SQL] select sum within transaction problem

2007-09-11 Thread Bart Degryse
Dear all I have a function like below (simplified). Everything works the way I want it to except for one thing. After the select statement sum_revenues is NULL instead of the real sum. Has this something to do with the earlier deletes and inserts not being committed yet? I assumed they would have