Re: [SQL] Sum() rows

2005-05-31 Thread Mark Dilger
Mark Dilger wrote: [EMAIL PROTECTED] wrote: Hi. How can I sum a row and show the sum for each row??? For example, in a finances table that have the total movimentation(debit/credit) in the bank. i.e: CREATE TABLE TB1 (id integer primary key, value numeric); insert into tb1 values (1,20

Re: [SQL] Sum() rows

2005-05-31 Thread Mark Dilger
[EMAIL PROTECTED] wrote: Hi. How can I sum a row and show the sum for each row??? For example, in a finances table that have the total movimentation(debit/credit) in the bank. i.e: CREATE TABLE TB1 (id integer primary key, value numeric); insert into tb1 values (1,20); insert into tb1 values (2,

[SQL] Explicitly rolling back transaction from within a C-Language function

2004-11-24 Thread Mark Dilger
Hello, I have a transactional system built on top of BerkeleyDB which I would like to call from within Postgres through a C-Language function. The behavior of the function will be read-only. Even so, the BerkeleyDB-based system's transaction will sometimes fail. What I would like to do is propo