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.