Hi,
I have not been able to find any help for this, and the postgreSQL docs 
weren't very clear to me, so I figured someone on the SLUG list could answer 
this.
I simply want to increment a column named 'id', which contains a serial 
number, in table 'b' every time an insert is performed in a table 'a'. I 
have tried the psql \h command and found the create trigger command, though 
it wasn't a great deal of help to this beginner.
Unfortunately, I have found no ANSI SQL documentation to show how to do 
this, and the docs I did find were confusing, or DBMS specific. Also, there 
is no standard SQL list to my surprise :(
Could someone explain how to do this? Does it require C functions, or can 
you use SQL procedures?
Thanks,
Alex
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

--
SLUG - Sydney Linux Users Group Mailing List - http://www.slug.org.au
To unsubscribe send email to [EMAIL PROTECTED] with
unsubscribe in the text

Reply via email to