From: | RobertD(dot)Stewart(at)ky(dot)gov |
---|---|
To: | desoi(at)pgedit(dot)com, richard(at)ibisaustralia(dot)com |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Table History |
Date: | 2004-12-17 15:51:24 |
Message-ID: | 06AF099D94D33B4D9120504521D6539D1038F9AD@agency33.state.ky.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Here is a example of a trigger function
CREATE OR REPLACE FUNCTION public.ipinfo_trg()
RETURNS trigger AS
'DECLARE
dhcp varchar:=\'DHCP\';
rtype varchar:=\'RAS\';
BEGIN
if NEW.ipaddress != dhcp then
if OLD.ipaddress != dhcp then
if OLD.atype != rtype then
insert into vpnip(ipaddress)
values(inet(OLD.ipaddress));
else
insert into rasip(ipaddress)
values(inet(OLD.ipaddress));
end if;
else end if;
else
if OLD.ipaddress != dhcp then
if OLD.atype != rtype then
insert into vpnip(ipaddress)
values(inet(OLD.ipaddress));
else
insert into rasip(ipaddress)
values(inet(OLD.ipaddress));
end if;
else end if;
END IF;
Return NEW;
END;
'
LANGUAGE 'plpgsql' VOLATILE;
Here is a example of how to call the trigger function from your table
CREATE TRIGGER update_ipinfo_trg
AFTER UPDATE
ON public.ipinfo
FOR EACH ROW
EXECUTE PROCEDURE public.ipinfo_trg();
-----Original Message-----
From: John DeSoi [mailto:desoi(at)pgedit(dot)com]
Sent: Friday, December 17, 2004 10:38 AM
To: Richard Sydney-Smith
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Table History
On Dec 17, 2004, at 1:23 AM, Richard Sydney-Smith wrote:
> I expect this has been done MANY times and I wonder if a general
> purpose trigger exists or if not then can someone point me to an
> example set of triggers?
I'm not aware of a "general purpose" trigger for this. If you just want
some extra trigger examples other than what is in the documentation,
there is a test file in the distribution with quite a few:
src/test/regress/sql/plpgsql.sql
Best,
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2004-12-17 16:43:14 | Re: can't get the order I want after inserting new rows |
Previous Message | John DeSoi | 2004-12-17 15:37:48 | Re: Table History |