simple trigger question ... - Mailing list pgsql-sql

From Marc G. Fournier
Subject simple trigger question ...
Date
Msg-id 20030402223933.M71125@hub.org
Whole thread Raw
Responses Re: simple trigger question ...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
I want to create a trigger on a table that for every insert, in performs a
nextval on a sequence ...

Something like:

CREATE TRIGGER on_company_company_id_seq    AFTER INSERT ON company FOR EACH ROW  EXECUTE PROCEDURE
nextval('company_company_id_seq');

I'm embaressingly new at triggers ... is this possible?



pgsql-sql by date:

Previous
From: Walter McGinnis
Date:
Subject: Re: pesky plpgsql
Next
From: Tom Lane
Date:
Subject: Re: simple trigger question ...