Create (function, procedure) and trigger to increment a counter

Started by Chris Barnesover 16 years ago1 messagesgeneral
Jump to latest
#1Chris Barnes
compuguruchrisbarnes@hotmail.com

I have a table usage, I would like to create a (function or procedure) called by the trigger to increment column counter after an update.

Can someone lend me a hand with the process behind creating this function,procedure and trigger.

Table "public.usage"
Column | Type | Modifiers
---------------+-----------------------+-----------
instrument | character varying(13) |
date | date |
counter | integer |

_________________________________________________________________
Internet explorer 8 lets you browse the web faster.
http://go.microsoft.com/?linkid=9655582