[HACKERS] How would I make a table of autonumbers/sequences?

2001-08-20 Thread Joseph Castille
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 A12255.32 B20132.20 Table2 CustID transactions A127 B2033 Every time something is ins

[HACKERS] Problems Converting Triggers From Oracle PLSQL to PLPGSQL

2001-08-20 Thread Joseph Castille
We're trying to migrate from Oracle to Postgres and I've been having problems converting the procedural language stuff. I've looked at the web documentation and my functions/triggers seem like they should work. What am I doing wrong? Any help you could give me would be greatly appreciated. I k