| 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: | Whole Thread | Raw Message | 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;
| 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 ... |