Triggers

From: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Triggers
Date: 2004-11-29 03:16:51
Message-ID: 41AA94A3.5040904@doitonce.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Just doing some testing at the moment and trying to make a trigger that
consists of a insert statement which as a result of an sql querty!

Is this possible? if so could someone give me some pointers as i am
having no luck trying to get this to work, have even tried this but
still doesnt work.

begin
begin
INSERT INTO wip.resourceplan
(
"name",
"notes",
"hrs",
"glcode1",
"glcode2",
"chargeratename",
"chargeratevalue",
"servicefeename",
"servicefeevalue")

('1','2','3','4','5','6','7','8','9')
return null;
end;

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2004-11-29 03:32:21 Re: [HACKERS] Adding Reply-To: <listname> to Lists configuration
Previous Message Bruce Momjian 2004-11-29 03:16:43 Re: [HACKERS] Adding Reply-To: <listname> to Lists configuration ...