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.stamp_lastupdate IS NULL THEN
NEW.stamp_lastupdate := 'now';
END IF;
RETURN NEW;
END;
$session_update$ LANGUAGE plpgsql;
CREATE TRIGGER session_update BEFORE INSERT OR UPDATE ON sessions FOR EACH
ROW EXECUTE PROCEDURE session_update();
Any help or suggestions of websites I should read would be appercated.
David
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
