try this:
create table a {
id int AUTO_INCREMENT PRIMARY KEY,
blah char(50),
};
the primary key isn't needed but you might want to use it...
Daniel
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Alex
Sent: Wednesday, May 31, 2000 11:49 AM
To: [EMAIL PROTECTED]
Subject: [SLUG] postgreSQL trigger help
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
--
SLUG - Sydney Linux Users Group Mailing List - http://www.slug.org.au
To unsubscribe send email to [EMAIL PROTECTED] with
unsubscribe in the text
