T OR UPDATE ON sessions FOR EACH
ROW EXECUTE PROCEDURE session_update();
I appercated the help Bricklen.
David
From: Bricklen Anderson <[EMAIL PROTECTED]>
To: David Hofmann <[EMAIL PROTECTED]>
CC: pgsql-sql@postgresql.org
Subject: Re: [SQL] Tigger
Date: Fri, 22 Jul 2005 12:28:
I'm using 7.3.
From: Bricklen Anderson <[EMAIL PROTECTED]>
To: David Hofmann <[EMAIL PROTECTED]>
CC: pgsql-sql@postgresql.org
Subject: Re: [SQL] Tigger
Date: Fri, 22 Jul 2005 12:17:41 -0700
David Hofmann wrote:
> I've look throught the docs and from what I can see the
I've look throught the docs and from what I can see the bellow code should
work, however I keep getting the error:
ERROR: parser: parse error at or near "$" at character 53
CREATE FUNCTION session_update() RETURNS trigger AS $session_update$
BEGIN
-- Check date exists
IF NEW.st
Ok, I have no knowledge of Tiggers except what I just read in the docs
section. Look like I need to make a procudure then call it with a trigger.
Is there a better location for Tigger/Procudure Examples. The trigger seems
fairly, however I got lost in the procudure part.
David
Normally you
of rule so that whenever a s_data field
is updated, that the time_stamp gets update to the current time/date. The
program regretab
I'm not really familar with rules, I've only used them in a certain places
and very limitedly.
Any help would be greatly appercated.
Dav
