I want to make a field in a table contain numbers that increment each
time a record is updated.  How would I go about doing this?


Example:

Table1
CustID     balance   
A12        255.32
B20        132.20

Table2
CustID     transactions   
A12        7
B20        33


Every time something is inserted or updated in table1 I want to
increment that customer's number of transactions in table2.  How would
I go about doing this?


TIA, 
Joseph

17 Aug 2001 06:58:38 -0700
joseph.castille@wcom.com (Joseph Castille)
How would I make a table of autonumbers/sequences?
On 17 Aug 2001 06:58:38 -0700, Joseph Castille <joseph.castille@wcom.com> wrote:
> I want to make a field in a table contain numbers that increment each
> time a record is updated.  How would I go about doing this?
> 
> 
> Example:
> 
> Table1
> CustID     balance   
> A12        255.32
> B20        132.20
> 
> Table2
> CustID     transactions   
> A12        7
> B20        33
> 
> 
> Every time something is inserted or updated in table1 I want to
> increment that customer's number of transactions in table2.  How would
> I go about doing this?
> 


This sounds like a good place for a trigger.

Did you ask this on the pgsql-general list yet?
You will probably have better luck there.


Fri, 17 Aug 2001 22:36:20 +0000 (UTC)
missive@frontiernet.net (Lee Harr)
Re: How would I make a table of autonumbers/sequences?